我把sql语句贴出来,大家帮我看看! select Z001Unsrsbh as 企业主代码, max(Z001Uqymc) as 企业名称, max(Z204Umc) as 地区, max(Z101Uzcdd) as 地区代码, max(Z203Umc) as 行业, max(Z101Uhylbdm) as 行业代码, max(Z201Usyzxsmc) as 经济类型, max(Z101Usyzdm) as 经济类型代码, sum(Z001Ulrze)/sum(Z001Uywsrje) as 企业效益 from T_EnterpriseReportforms001,T_EnterpriseData,D_DistrictCode,D_VocationClass,D_BelongStyle where to_char(Z001Usbsj,'yyyy')='2003' and T_EnterpriseReportforms001.Z001Unsrsbh=T_EnterpriseData.Z101Unsrsbh(+) and T_EnterpriseData.Z101Uzcdd=D_DistrictCode.Z204Ubh(+) and T_EnterpriseData.Z101Uhylbdm=D_VocationClass.Z203Ubh(+) and T_EnterpriseData.Z101Usyzdm=D_BelongStyle.Z201Usyzxsdm(+) group by T_EnterpriseReportforms001.Z001Unsrsbh having sum(T_EnterpriseReportforms001.Z001Uywsrje)<>0 order by 企业效益 desc
而且pl/sql我也不大会用,我就是想直接从数据库里读数据,也有问题吗?
select Z001Unsrsbh as 企业主代码,
max(Z001Uqymc) as 企业名称,
max(Z204Umc) as 地区,
max(Z101Uzcdd) as 地区代码,
max(Z203Umc) as 行业,
max(Z101Uhylbdm) as 行业代码,
max(Z201Usyzxsmc) as 经济类型,
max(Z101Usyzdm) as 经济类型代码,
sum(Z001Ulrze)/sum(Z001Uywsrje) as 企业效益
from T_EnterpriseReportforms001,T_EnterpriseData,D_DistrictCode,D_VocationClass,D_BelongStyle
where to_char(Z001Usbsj,'yyyy')='2003'
and T_EnterpriseReportforms001.Z001Unsrsbh=T_EnterpriseData.Z101Unsrsbh(+)
and T_EnterpriseData.Z101Uzcdd=D_DistrictCode.Z204Ubh(+)
and T_EnterpriseData.Z101Uhylbdm=D_VocationClass.Z203Ubh(+)
and T_EnterpriseData.Z101Usyzdm=D_BelongStyle.Z201Usyzxsdm(+)
group by T_EnterpriseReportforms001.Z001Unsrsbh
having
sum(T_EnterpriseReportforms001.Z001Uywsrje)<>0
order by 企业效益 desc