Oracle rownum in Greenplum

posted Apr 28, 2017, 10:18 AM by Sachchida Ojha
select row_number() over() as id, t.* from pg_tables t;

works similar like oracle rownum.
Comments