如果Message如下,你就对了,呵呵 SELECT 项目名称,SUM(金额) FROM Project_Expense WHERE 项目名称='444weqweqdfff' or 项目名称='5555'
多谢楼上两位 语法错误解决了,但是多了新的错误: Column 'Project_Expense.项目名称' is invalid in the select list because it is not contained in an aggregate function and there is no GROUP BY clause. 请问怎么解决
SELECT 项目名称,SUM(金额) FROM Project_Expense WHERE 项目名称='444weqweqdfff' or 项目名称='5555' group by 金额,项目名称
SELECT 项目名称,SUM(金额) FROM Project_Expense WHERE 项目名称='444weqweqdfff' or 项目名称='5555'
语法错误解决了,但是多了新的错误:
Column 'Project_Expense.项目名称' is invalid in the select list because it is not contained in an aggregate function and there is no GROUP BY clause.
请问怎么解决