CREATE GLOBAL TEMPORARY TABLE
(
[COLUMN DEFINTION]
) ON COMMIT [DELETE | PRESERVE] ROWS;
on commit delete rows,
it means when you commit the row which you insert, then there is no data in the temp table(in the same session)
on commit perserve rows,
it measns when you do commit, the data still existd in the table, only current session is able to check it.
=VLOOKUP(D2,'Sheet 1 (2)'!$D$2:$D$43,1,0)
1. first choose a value as the parameter 1
2. choose the search area, but don't forget to add a $ maually (if not, the seach area will change when we copy the vlookup)
3. click the column when it displays a +
scroll down , then we will get the result.
(
[COLUMN DEFINTION]
) ON COMMIT [DELETE | PRESERVE] ROWS;
on commit delete rows,
it means when you commit the row which you insert, then there is no data in the temp table(in the same session)
on commit perserve rows,
it measns when you do commit, the data still existd in the table, only current session is able to check it.
=VLOOKUP(D2,'Sheet 1 (2)'!$D$2:$D$43,1,0)
1. first choose a value as the parameter 1
2. choose the search area, but don't forget to add a $ maually (if not, the seach area will change when we copy the vlookup)
3. click the column when it displays a +
scroll down , then we will get the result.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/13975809/viewspace-2131653/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
