SELECT c.xitongshijian,sum(c.zongyeji) FROM count_report c group by c.xitongshijian;根據(jù)count_report的時間分組統(tǒng)計總業(yè)績，然后根據(jù)count_report的時間再查詢統(tǒng)計另一張表的總業(yè)績。寫完了select t1.xitongshijian,t1.zyj,t2.xf from (SELECT xitongshijian,sum(zongyeji) as zyj FROM count_report group by xitongshijian )t1 left join (select xitongshijian,sum(xiaofei) as xf from shangwutong group by xitongshijian) t2 on t1.xitongshijian=t2.xitongshijian
1 回答
蠱毒傳說
TA貢獻1895條經驗 獲得超3個贊
不是很明白，不過大致猜想你是想要 select field from tableName where field in (select field from tableName group by field )
添加回答
舉報
0/150
提交
取消