sql中查询第31到第40行之间的数据 主键ID不一定是连续的,何解??? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select * from (SELECT ROW_NUMBER() over ( order by id desc) as id ,* from table )a where id between 31 and 40 select top 10 * from (select top 40 * from tableA order by id desc) order by id asc 3楼是2005,用top吧,这个不就是分页吗 select top 10 * from table1 where id not in (select top 30 id from table1) SELECT * FROM (SELECT TOP 40 * FROM 表A ORDER BY ID) A WHERE ID NOT IN (SELECT TOP 30 ID FROM 表A ORDER BY ID) SELECT IDENTITY(INT,1,1) AS ID2 ,* INTO #TABLE FROM TABLE1 SELECT * FROM #TABLE WHERE ID2 BETWEEN 31 AND 40 SELECT TOP 10 * FROM (SELECT TOP 40 * FROM TABLE ORDER BY ID ASC)A ORDER BY ID DESC SELECT TOP 10 * FROM (SELECT TOP 40 * FROM TABLE ORDER BY ID ASC)A ORDER BY ID DESC推荐这个,不赞成用not in 再排一次就行了SELECT * FROM (SELECT TOP 10 * FROM (SELECT TOP 40 * FROM TABLE ORDER BY ID ASC)A ORDER BY ID DESC)B ORDER BY ID ASC 7L那种方法不行的。如果ID是断的就不能这样做了。SELECT * FROM table LIMIT 31,40;轻松搞定 如果是sqlserver 的话用这个吧select * from(select top 3 * from (select top 10 * from books order by bno)a order by bno desc)a order by bno asc 弱弱的请教个问题 ... 同时播放两个声音 excel导入到sqlserver错误 请问:在程序结束时该怎样卸载之前隐藏的窗体。 今天我去富士康的c#笔试题。请各位大哥帮帮我呀。非常感谢呀。 数据类型转换的简单问题,在线等**************! 截取字符串 怎么查看某个端口是否在使用-(急呼高手,急啊) 求教高手:一个新手怎样尽快掌握C#啊?有没有什么好的网址啊? !!!!!!!!! 关于ASP.NET中关于C#代理的若干问题请教! 。NET里用C#怎么通过文本框,可以把内容输入到XML文件里? C#开发wince,关于图片、视频问题
select * from (SELECT ROW_NUMBER() over ( order by id desc) as id ,* from table )a where id between 31 and 40
(SELECT TOP 40 * FROM 表A ORDER BY ID) A
WHERE ID NOT IN (SELECT TOP 30 ID FROM 表A ORDER BY ID)
SELECT IDENTITY(INT,1,1) AS ID2 ,* INTO #TABLE FROM TABLE1 SELECT * FROM #TABLE WHERE ID2 BETWEEN 31 AND 40
SELECT TOP 10 * FROM (SELECT TOP 40 * FROM TABLE ORDER BY ID ASC)A ORDER BY ID DESC
SELECT TOP 10 * FROM (SELECT TOP 40 * FROM TABLE ORDER BY ID ASC)A ORDER BY ID DESC
推荐这个,不赞成用not in
再排一次就行了
SELECT * FROM (SELECT TOP 10 * FROM (SELECT TOP 40 * FROM TABLE ORDER BY ID ASC)A ORDER BY ID DESC)B ORDER BY ID ASC
轻松搞定