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有什么错呢?
谢谢~~
FROM AA order by AA.ryid asc中间这句select ccc from BB where BB.ryid=AA.ryid and rownum =1 order by SJ有什么错呢?
谢谢~~
解决方案 »
- Oracle11g安装
- 请教ORACLE Left Join的问题
- Oracle 如何可视化定义外键,在线等.....
- 登陆广域网中的oracle数据库,怎样才能不让管理员查出我的IP地址?
- oracle10g 的服务和数据存储位置问题?(在线等)
- 调试存储过程
- 10g数据库启动错误提示:Io 异常: The Network Adapter could not establish the connection
- 问 windows 2003 server 下安装oracle 92 ?
- 有关oracle9i的TNSListener的三个端口的讨论
- 急!!!通过列号取不到值,还有.....
- 数据库挂掉,大家可参考!不相信者可以试试。
- DBWR LGWR
FROM AA order by AA.ryid asc
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