access:
select top (10) * from table1
db2:
select 列名 from table1 where 1=1 fetch first 10 rows only
mysql:
select * from table1 limit 10 或 select * from table1 limit 0,10
sql server:
读取前10条:select top (10) * from table1 where 1=1
在sqlserver里面,若每页显示perpage条记录,按照id的排序,取第pageno页的记录:
select top perpage*pageno * from table where id not in(select top (pageno-1)*perpage id from table1)
oracle取前10条:
select * from table1 where rownum<=10
oracle取第11-20条:
select * from (select *,rownum num from table1 where rownum<=20) where num>=10;
oracle按id排序后取11-20条
select * from (select *,rownum num from (select * from table1 tt order by id desc) where rownum<=20) where num>=10;
关于mysql 的limit 子句的使用方法: