且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

DB2是否支持使用ORDER BY子句的SELECT-INTO语句?

更新时间:2023-10-23 15:46:52

仅将FETCH FIRST 1行放入在FOR READ ONLY之前和OPTIMIZE FOR 1

ROW。


" FETCH FIRST 1 ROW ONLY"是Subselect的一部分。

FOR READ ONLY和优化1行是select-sttement的一部分。

Put "FETCH FIRST 1 ROW ONLY" before "FOR READ ONLY" and "OPTIMIZE FOR 1
ROW".

"FETCH FIRST 1 ROW ONLY" is part of Subselect.
"FOR READ ONLY" and "OPTIMIZE FOR 1 ROW" are part of Select-sttement.


即使这不起作用。

Even this does not work.


您使用的是什么DB2版本和平台?

What DB2 version and platform are you using?