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 ...
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 ...
一部の結果でアクセス不可の可能性があるため、非表示になっています。
アクセス不可の結果を表示する