怎样sql语句在SQL Server里面取出指定的一些数据（如从第50行开始取100行)

[jom_ch]

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分,真不好意思!

[HouJinkun2005]

帮你Up一下了。

[李欣欣1981]

select top 50 * from
(select top 100 * from tablename order by columnname) a
order by columnname desc

[108041217]

mysql: select * from Table where condition limited BeginPos,10 (每次取10條)

不同的數據庫不同的寫法.

[liutang2]

关注

[李欣欣1981]

http://forum.javaeye.com/viewtopic.php?t=261&postdays=0&postorder=asc&start=0

[programdolt]

关注

[lndlmy]

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

[fbtdjs]

select * from tb_yourtable where rownum < 100 MINUS select * from tb_yourtable where rownum < 50

[programdolt]

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