SQL分组统计且跨表查询

发布网友

我来回答

4个回答

热心网友

SELECT Table2.t_name,sum(Table1.s_total) FROM Table1,Table2 WHERE Table1.s_date LIKE '2013-02-__' GROUP BY Table2.t_name

SELECT Table2.t_id,sum(Table1.s_total) FROM Table1,Table2 WHERE Table1.s_date LIKE '2013-02-__' GROUP BY Table2.t_id

SELECT Table2.t_id,Table2.t_name,sum(Table1.s_total) FROM Table1,Table2 WHERE Table1.s_date LIKE '2013-02-__' GROUP BY Table2.t_id,Table2.t_name
group by 至少要包括除了函数之外的所有SELECT的字段

热心网友

SELECT Table2.t_name,sum(Table1.s_total) FROM Table1,Table2 WHERE Table1.s_date LIKE '2013-02-__' GROUP BY Table2.t_name
这样就对了,你要group by 你查询的字段名追问你有没有试过,我试过了,不行,select出来的结果会把我不要的结果都列出来,而且数据也都错了,求助啊

追答SELECT Table2.t_name,count(Table1.s_total) FROM Table1,Table2 WHERE Table1.s_date LIKE '2013-02-__' GROUP BY Table2.t_name
把SUM改成COUNT试试。

热心网友

SELECT 
  TABLE1.T_ID,
  TABLE2.T_NAME,
  SUM(TABLE1.S_TOTAL)  
FROM TABLE2,TABLE1
WHERE 
  TABLE1.T_ID=TABLE2.T_ID AND TABLE1.S_DATE LIKE '2013-02-__' 
  GROUP BY TABLE1.T_ID,TABLE2.T_NAME

热心网友

SELECT Table2.t_name,sum(Table1.s_total) FROM Table1,Table2 WHERE Table1.s_date LIKE '2013-02-__' GROUP BY Table2.t_name

声明声明:本网页内容为用户发布,旨在传播知识,不代表本网认同其观点,若有侵权等问题请及时与本网联系,我们将在第一时间删除处理。E-MAIL:11247931@qq.com