News

GitHub10mon

row_number.sql

select *, row_number() over (order by cid desc) as num from items select * from (select *, row_number() over (order by cid desc) as RowNum from items) t2 where t2.RowNum=5 ...
GitHub7mon

Avg_sales_by_segment_with_row_number.sql

AVG(s.sales) OVER (PARTITION BY c.segment) AS avg_sales_by_segment, ROW_NUMBER() OVER (PARTITION BY c.segment ORDER BY s.sales DESC) AS row_number ...