SQL返回特定行的rownum？(使用Oracle db)

SELECT * FROM (
  SELECT rownum AS rn, a.* FROM (
    SELECT * FROM your_table_name
  ) a
) WHERE rn = your_desired_row_number;

SELECT * FROM (
  SELECT rownum AS rn, a.* FROM (
    SELECT * FROM employees
  ) a
) WHERE rn = 5;