|
楼主 |
发表于 2013-1-9 17:57:38
|
显示全部楼层
jishuang 发表于 2013-1-9 17:22
用order by排序啊
select a.fDGSBMMC ,a.fFYXMC ,a.fJE from (select fDGSBMMC ,fFYXMC ,fJE, fZZZD from VE_BMGSSQ,VE_BMKM,VE_GSMX where VE_BMGSSQ.fID = VE_GSMX.fSQDID and VE_GSMX.fFYXBID =VE_BMKM.fID and VE_BMGSSQ.fDGSXMMC = 'Demo4') a,(select fDGSBMMC, fFYXMC ,(max(fZZZD)) mFZZD from VE_BMGSSQ,VE_BMKM,VE_GSMX where VE_BMGSSQ.fID = VE_GSMX.fSQDID and VE_GSMX.fFYXBID =VE_BMKM.fID and fDGSXMMC = 'Demo4' group by fFYXMC,fDGSBMMC ) b where a.fDGSBMMC = b.fDGSBMMC and a.fFYXMC = b.fFYXMC and a.fZZZD = b.mFZZD 用这条sql解决了 |
|