Oracle兩表聯(lián)合查詢group？
select * from (SELECT b.CLIENTNO,b.CNAME,SUM(a.AMOUNT) TAMOUNT FROM PURCHASE a, CLIENT b where a.CLIENTNO=b.CLIENTNO GROUP BY a.CLIENTNO order by TAMOUNT) aa where rowNum=1
網(wǎng)站導航
- zblogPHP模板zbpkf
- zblog免費模板zblogfree
- zblog模板學習zblogxuexi
- zblogPHP仿站zbpfang