Question

sql 语句如何取中间几条记录,我现在只知道有top *

select top 5 * from (select top 10 * from a order by column1) order by column1 desc
以上的不可用

Answer 1

取第5条到第10条间的记录:

select top 5 * from (select top 10 * from a order by column1) order by column1 desc

谢谢加分啊!:)

Answer 2

不能吧,

Answer 3

go 5
select next 5

Answer 4

好久不用sql，都忘记了 加个条件不久可以了吗 ？