Greenplum语句例子

SELECT *
 FROM test limit 10 offset 19;
 

SELECT gender, row_number() over(partition by gender order by t.username)
 FROM test t  order by 2 limit 10;