请指教! 怎样用查寻的语句读取10-20条记录?请指教把SQL语句写出来,谢谢!! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select top 10 * from (select top 20 * from table order by field desc) a order by field asc SELECT TOP 10 *FROM TestTableWHERE (ID >(SELECT MAX(id)FROM (SELECT TOP 20 idFROM TestTableORDER BY id) AS T))ORDER BY ID SELECT TOP 10 *FROM TestTableWHERE (ID NOT IN(SELECT TOP 10 idFROM TestTableORDER BY id))ORDER BY ID select ID=identity(int,1,1),* into #tmp from tbName select * from #tmp where ID between 10 and 20 如何实现汇总并取第一条记录 SQL语句,desc top100条数据出来再asc排序,如何来做? SQL Server的多表查询问题 如何导出sql server数据库里保存的图片 菜2鸟问题 未能找到存储过程是何缘故? 自动增量 sql 表加锁的问题 sql數據庫中,是否可以讓某些比較重要的表不顯示出來(已經設了權限,)?? **************脱离了“追星族”,散分!!!!!呵呵************ 怎样求字符串长度 DBCC CHECKIDENT 中能使用变量吗?
FROM TestTable
WHERE (ID >
(SELECT MAX(id)
FROM (SELECT TOP 20 id
FROM TestTable
ORDER BY id) AS T))
ORDER BY ID
FROM TestTable
WHERE (ID NOT IN
(SELECT TOP 10 id
FROM TestTable
ORDER BY id))
ORDER BY ID