select a.xlid,
b.zdid qszid,
b.zdmc qszmc,
b.zddz qszdz,
c.zdid zzzid,
c.zdmc zzzmc,
c.zddz zzzdz
from (select xlid, min(to_number(zdsxh)) xh1, max(to_number(zdsxh)) xh2
from jjwgps_t_zdlyb
where szgjfx = 0
group by xlid) a,
(select xlid, zdid, zdsxh, zdmc, zddz
from jjwgps_t_zdlyb
where szgjfx = 0) b
where a.xlid = b.xlid
and (a.xh1 = b.zdsxh or a.xh2 = b.zdsxh)
解决方案 »
- 通过PL/SQL Developer中的ODBC Importer导数据时发生如下错误,各位高手帮忙看看什么原因?
- 查看某个用户下是否存在某张表
- orcle数据库导出以后,重新安装数据库,再导入报错
- 在线等,急哈!!求从SQL转换成Oracle存储过程。
- 请问这样能实现数据恢复
- ORACLE8.1.6的managermentserver启动有问题?提示I/O重复操作,是怎么一回事情?
- !!!oracle故障,请帮忙!!!
- 怎么赋值给list item?
- 在配置oracle客户端是,有几个什么名的到底指什么东西(像主机名,数据库名)~
- 创建oracle function问题请教,谢谢了
- Oracle RAC 集群 OEM创建服务报错
- 请教一个比较复杂的统计SQL怎么写?
max(zdid)keep(dense_rank first order by zdsxh)qszid,
max(zdmc )keep(dense_rank first order by zdsxh)qszmc,
max(zddz )keep(dense_rank first order by zdsxh)qszdz ,
max(zdid)keep(dense_rank last order by zdsxh)zzzid,
max(zdmc )keep(dense_rank last order by zdsxh)zzzmc,
max(zddz )keep(dense_rank last order by zdsxh)zzzdz
from jjwgps_t_zdlyb where szgjfx=0 group by xlid;
ORA-00904: "C"."ZDDZ": invalid identifier
已经解决,你真厉害!