select row number pada postgresql

 select * from 

(

SELECT nim,count(*) as jml,ROW_NUMBER () OVER (ORDER BY npm) as no FROM public.data where periode='123' group by nim

) a 

 where a.no>=100 and a.no<=150


Posting Lebih Baru Posting Lama

Leave a Reply