Oracle数据库:
select * from (select * from tab order by id desc) where rownum <= 10;
MySQL数据库:
select * from tab order by id desc limit 0, 10;
(这里就是从第一行开始,一共查询10行。)
MSSQL与Access数据库
select top 10 * from tab order by id desc
Oracle数据库:
select * from (select * from tab order by id desc) where rownum <= 10;
MySQL数据库:
select * from tab order by id desc limit 0, 10;
(这里就是从第一行开始,一共查询10行。)
MSSQL与Access数据库
select top 10 * from tab order by id desc