如何通过sql语句完成分页？

oracle

 

select rownum,bookId from

[rownum是伪列名,bookId是列名]

(select rownum row_id,bookId from xiaoWJ_books t)

t where row_id between 10 and 20

[查10到20条记录]

 

mysql

 

sql="select * from xiaoWJ_books LIMIT ?,?";

第一个?是开始位置,第二个?是每页显示多少

 

 

sqlServer2000

 

select top "+pageSize+" * from xiaoWJ_books where bookId not in

[去掉前面 "+pageBegin+" 条后显示 "+pageSize+" 条记录]

(select top "+pageBegin+" bookId from xiaoWJ_books order by bookId)

[查出整个表的前 "pageBegin" 条记录]

order by bookId"