java吧 关注：1,297,740贴子：12,833,516
- 2回复贴，共1页
不感兴趣
开通SVIP免广告
select id,station_name,parent_id,root_id,img_count,station_addr
from (select row_number() over(order by index_of) as row_num,a.*
from xrongeap..tbl_sunroam_station a where a.root_id=1 and a.parent_id!=1and show_able=1 ) as b where b.row_num>"+startIndex+" and b.row_num<="+endIndex;
这里的row_number() 只支持sqlserver2005以上的版本
from (select row_number() over(order by index_of) as row_num,a.*
from xrongeap..tbl_sunroam_station a where a.root_id=1 and a.parent_id!=1and show_able=1 ) as b where b.row_num>"+startIndex+" and b.row_num<="+endIndex;
这里的row_number() 只支持sqlserver2005以上的版本
扫二维码下载贴吧客户端
下载贴吧APP
看高清直播、视频！
看高清直播、视频！
贴吧热议榜
- 1湖北爆炸12死,年关变鬼门1652400
- 2终末地建模,AI偷偷加料1156955
- 3致敬阿凡达?河南春晚骇死人848064
- 4冬奥首金落袋!苏翊鸣生日夺金811188
- 5好事成双,徐梦桃冬奥卫冕794820
- 6苟延残喘,A站拜年纪凉透730075
- 7岛国纯幻想!国产科技已杀疯592752
- 8机器人变印度造,三哥真敢吹516718
- 9papi酱反讽某晚视频遭下架497376
- 10钓鱼佬立功,吧友勇救轻生女孩478002
