oracle统计数据时,涉及两个表的数据

SELECT t1.*,a.num FROM (SELECT SUM(t.total_profit) total_profit, SUM(t.main_business_income) main_business_income, COUNT(t.name_of_legal_representa) n
posted @ 2018-04-16 15:41  静候。  阅读(517)  评论(0编辑  收藏  举报