SELECT * FROM
(
SELECT ROW_NUMBER() OVER(ORDER BY FSalary DESC) row_num,
FNumber,FName,FSalary,FAge FROM T_Employee
) s
WHERE s.row_num>=3 AND s.row_num<=5
ORA
最新推荐文章于 2023-03-24 20:43:36 发布
SELECT * FROM
(
SELECT ROW_NUMBER() OVER(ORDER BY FSalary DESC) row_num,
FNumber,FName,FSalary,FAge FROM T_Employee
) s
WHERE s.row_num>=3 AND s.row_num<=5