select bmzd_bmbh,bmzd_mc,bmzd_js,bmzd_fzr,bmzd_dz from bmzd order by bmzd_lsh desc limit 50,100上面是mySql里面的语句,不知道在sql server里面怎么实现,谢谢帮忙,这是我在用jsp+mssql做分页程序的时候遇到的问题, 只要这10分,真不好意思!
select top 50 * from (select top 100 bmzd_bmbh,bmzd_mc,bmzd_js,bmzd_fzr,bmzd_dz from bmzd order by bmzd_lsh) a order by bmzd_lsh desc
select * from tb_yourtable where rownum < 100 MINUS select * from tb_yourtable where rownum < 50
SELECT TOP 10 * FROM Products WHERE (ProductID > (SELECT MAX(ProductID) FROM (SELECT TOP 50 ProductID FROM Products ORDER BY ProductID) AS T)) ORDER BY ProductID
(select top 100 * from tablename order by columnname) a
order by columnname desc
FROM Products
WHERE (ProductID >
(SELECT MAX(ProductID)
FROM (SELECT TOP 50 ProductID
FROM Products
ORDER BY ProductID) AS T))
ORDER BY ProductID