分页存储过程的一个小问题
select top 10 *
from msgbox
where msgbox.id <(select min(msgbox.id) from (select top 10 msgbox.id from msgbox order by msgbox.id desc))
order by msgbox.id desc
为什么总是提示：Incorrect syntax near ') '.
我单独运行
select min(msgbox.id) from (select top 10 msgbox.id from msgbox)
也是提示：Incorrect syntax near ') '.
请指点，谢谢
[解决办法]
select top 10 *
from msgbox
where msgbox.id <(select min(msgbox.id) from (select top 10 msgbox.id from msgbox order by msgbox.id desc)a)
order by msgbox.id desc
少了临时表名
