這個語句執行后﹐查詢出來很多name值一樣﹐但是money不同的記錄﹐
我想要的結果是﹐2006年中﹐name數值要唯一﹐money值累加,請問這個語句如何改寫﹐謝謝。SELECT NAME,SUM(money) AS money,SUBSTR(MONTH1,1,4) AS YEAR FROM JYYB
WHERE substr(MONTH1,1,4)='2006' GROUP BY NAME,month1
我想要的結果是﹐2006年中﹐name數值要唯一﹐money值累加,請問這個語句如何改寫﹐謝謝。SELECT NAME,SUM(money) AS money,SUBSTR(MONTH1,1,4) AS YEAR FROM JYYB
WHERE substr(MONTH1,1,4)='2006' GROUP BY NAME,month1
WHERE substr(MONTH1,1,4)='2006' GROUP BY NAME,month1
GROUP BY NAME,month1 名字,月份汇总如果只要名字汇总,那lz的月份怎么处理
WHERE substr(MONTH1,1,4)='2006' GROUP BY NAME,SUBSTR(MONTH1,1,4)
WHERE substr(MONTH1,1,4)='2006' GROUP BY NAME,YEAR 不知道這樣對否, 菜鳥答題.
干脆这样写吧:
SELECT NAME,SUM(money) AS money,SUBSTR(MONTH1,1,4) AS YEAR FROM JYYB
WHERE substr(MONTH1,1,4)='2006' GROUP BY NAME
SELECT NAME,SUM(money) AS money,‘2006’ AS YEAR FROM JYYB
WHERE substr(MONTH1,1,4)='2006' GROUP BY NAME