高手麻烦帮个忙？
select top 10 iid from where iid <(
select min(iid) from
(select top 20 iid from info order by iid desc)
) order by iid
下面的这个语句总是报错：incorrect syntax near the keyword 'where '
an order by clause is not allowed in a derived table
------解决方案--------------------------------------------------------
错误已经很明显了,order by 子句不能用在派生表中.