Oracle rownum in Greenplum

Post date: Nov 11, 2014 11:48:49 PM

select row_number() over() as id, t.* from pg_tables t;

works similar like oracle rownum.