求一sql语句:数据库里有400条记录,能不能查询显示360—380之间的20条记录(Sql Server)

[blackhero]

求一sql语句:数据库里有400条记录,能不能查询显示360—380之间的20条记录(Sql Server)

select top 20 from table .......


Thank You!!!

-------------------------blackhero-----------------------------------------------

[leocool]

SELECT TOP 20 *
FROM TestTable
WHERE (ID >
(SELECT MAX(id)
FROM (SELECT TOP 360 id
FROM TestTable
ORDER BY id) AS T))
ORDER BY ID

[blackhero]

MAX(id)

是不是
(SELECT TOP 360 id
FROM TestTable
ORDER BY id) AS T))的最后一个id的值呀

[jimu8130]

学习

[jimu8130]

对，就是最后一个值

[egonzou]

select top 20 * from tablename where id not in (select top 360 id from tablename order by id asc) order by is asc

[ppzhlmt]

严重同意楼上观点
SELECT Top 20 *
FROM TableName
WHERE id Not In (
SELECT TOP 360 Id
FROM tablename
ORDER BY Id
)
OEDER BY Id

[xvhaijun]

学习……

[layueer]

这是分页问题啊

[chxuxu]

如果你数据库里有递增字段这样就可以了吧：
SELECT Top 20 *
FROM TableName
WHERE 递增字段>360

[zogae]

上上上上楼的大哥， 为什么要加 ORDER BY ID呢？

[ieooo]

稍微修改一下 leocool(金属外壳) 的方法：
SELECT *
FROM TestTable
WHERE (ID >
(SELECT MAX(id)
FROM (SELECT TOP 360 id
FROM TestTable
ORDER BY id) AS T) AND ID < 380)
ORDER BY ID
这样不管你的Id是否连续都可以查出Id值在360与380之间的记录。

[blackhero]

ID是唯一主键:

不一定是 0-400 （数字）

不过也谢谢了

[Toti]

select top 20 * from select * from table where id<= 400 as table order by id desc
看看这个能不能实现，以前我用这个实现了取到20--30里面的数据

[Toti]

select top 20 * from select * from table where id<= 380 as table order by id desc