数据仓库服务 GAUSSDB(DWS)-FETCH:语法格式

时间:2024-04-18 16:25:16

语法格式

1
FETCH [ direction { FROM | IN } ] cursor_name;

其中direction子句为可选参数。

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
NEXT
   | PRIOR
   | FIRST
   | LAST
   | ABSOLUTE count
   | RELATIVE count
   | count
   | ALL
   | FORWARD
   | FORWARD count
   | FORWARD ALL
   | BACKWARD
   | BACKWARD count
   | BACKWARD ALL
support.huaweicloud.com/sqlreference-830-dws/dws_06_0216.html