select * from (
select my_table.*, rownum as my_rownum from (
select name, birthday from employee order by birthday)
my_table where rownum =100
=============================================================
看这个my_table 是不是 (select name, birthday from employee order by birthday)结果集 的一个别名或者说是引用?