select top 10 * from Orders where OrderID not in(select top 10 OrderID from Orders)
select top 10 * from Orders where OrderID not in(select top 20 OrderID from Orders)
select top 10 * from Orders where OrderID not in(select top 30 OrderID from Orders)我想用上面的这段代码来实现分页,但是上面的3条语句却返回一样的结果,这是为什么呢?
select top 10 * from Orders where OrderID not in(select top 20 OrderID from Orders)
select top 10 * from Orders where OrderID not in(select top 30 OrderID from Orders)我想用上面的这段代码来实现分页,但是上面的3条语句却返回一样的结果,这是为什么呢?
select top 10 * from Orders where OrderID not in(select top 20 OrderID from Orders) order by OrderID ASC
select top 10 * from Orders where OrderID not in(select top 30 OrderID from Orders) order by OrderID ASC
结果还是一样,请教各位,是那里出了错
其中i为每页需要显示的数目,j的2取值范围为:0, i, 2i, 3i, 4i, …… ;select top i * from CateGories
where CateGoryID not in( select top j CateGoryID from CateGories )
这样就好了的
select top 10 * from Orders where OrderID not in(select top 10 OrderID from Orders order by OrderID asc)
select top 10 * from Orders where OrderID not in(select top 20 OrderID from Orders order by OrderID asc)
select top 10 * from Orders where OrderID not in(select top 30 OrderID from Orders order by OrderID asc)