sybase 中的top有关问题?

sybase 中的top问题??高手麻烦帮个忙?selecttop10iidfromwhereiid (selectmin(iid)from(selecttop20iidfr

sybase 中的top问题??
高手麻烦帮个忙?
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 子句不能用在派生表中.