sql - 无法通过行号获取记录

Question

我收到此查询的错误

select ID, ROW_NUMBER() OVER(ORDER BY ID) as num from T_TASK where ROW_NUMBER() = 5

还有这个

select ID, ROW_NUMBER() OVER(ORDER BY ID) as num from T_TASK where num = 4

查询有什么问题？

Answer 1

SELECT ID
FROM
(select ID, ROW_NUMBER() OVER(ORDER BY ID) as rownum from T_TASK) dr
WHERE rownum = 5