表内容如下: BALANCE ACCOUNTNO ---------- ---------- 1000 1 1000 2 1000 3 1000 4 1000 5 在oracle数据库中查询结果的行号使用伪列ROWNUM表示(从1开始)。需要注意rownum是在查询之后排序之前赋值的。 查前2行: select * from account where rownum<3; 查后两行(知道总行数): select * from (select rownum as rowno,balance,accountno from account) t where t.rowno>3; 查后两行(不知道总行数): select * from (select rownum as rowno,balance,accountno from (select balance,accountno from account order by rownum desc)) t where t.rowno<3; 查第2至第4行 select * from (select rownum as rowno,balance,accountno from account) t where t.rowno>=2 and t.rowno<=4;