select ymbh,ph,min(yxq)yxq,sl from kc group by ymbh,ph,sl having min(yxq)=(select min(yxq) from kc a where a.ymbh=kc.ymbh)
sqlserver 运行正常
在oracle里不能正常运行,好像是在死循环
...全文
912打赏收藏
Oracle sql语句问题
select ymbh,ph,min(yxq)yxq,sl from kc group by ymbh,ph,sl having min(yxq)=(select min(yxq) from kc a where a.ymbh=kc.ymbh) sqlserver 运行正常 在oracle里不能正常运行,好像是在死循环