OLAP関数の使用例

軍鶏/ 7月 7, 2020/ 未分類

SELECT name,id
FROM(
(SELECT name,id,row_number() over(ORDER BY id) as p_rownum
FROM (select name,id from test where name=’hogehoge’)))
WHERE p_rownum between 3 and 8;