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

时间：2025-02-12 15:04:42

示例

开始一个事务：

  
       START TRANSACTION;

定义一个名为cursor1的游标：

  
       CURSOR cursor1 FOR SELECT * FROM tpcds.reason;

忽略游标cursor1的前3行：

  
       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)