数据仓库服务 GAUSSDB(DWS)-MOVE:示例

时间：2023-11-10 17:34:10

示例

开始一个事务：

1	START TRANSACTION;

定义一个名为cursor1的游标：

1	CURSOR cursor1 FOR SELECT * FROM tpcds.reason;

忽略游标cursor1的前3行：

1	MOVE FORWARD 3 FROM cursor1;

抓取游标cursor1的前4行：

FETCH 4 FROM cursor1;
 r_reason_sk |   r_reason_id    |                                            r_reason_desc                                             
-------------+------------------+------------------------------------------------------------------------------------------------------
           4 | AAAAAAAAEAAAAAAA | Not the product that was ordred                                                                     
           5 | AAAAAAAAFAAAAAAA | Parts missing                                                                                       
           6 | AAAAAAAAGAAAAAAA | Does not work with a product that I have                                                            
           7 | AAAAAAAAHAAAAAAA | Gift exchange                                                                                       
(4 rows)