奇怪了，这样子怎么不让我排序呢？总报缺少右括号
select AA.*, (select ccc from BB where BB.ryid=AA.ryid and rownum =1 order by SJ) as CCC
FROM AA order by AA.ryid asc

中间这句select ccc from BB where BB.ryid=AA.ryid and rownum =1 order by SJ有什么错呢？
谢谢～～

[解决办法]
不知什么，可能子查里不能有order by ,但也可以：

select AA.*,tt.ccc
from
AA,
(
select ccc,t.ryid from BB v,
(select min(sj) sj,ryid from BB group by ryid)t
where t.sj=v.sj and t.ryid=v.ryid
)tt
where AA.ryid=tt.ryid