select ssfj,dss,qybm,qymc,sum (rs),sum (sre),sum (msxmhj),sum (ynse),sum (jmse),sum(sjynse) from bims_sbqktjb200712 group by ssfj,dss,qybm,qymc where qybm='220102794440621' 在WHERE的'W' 那儿点*了
调试欢乐多
group by 子句应该放在 where 子句的后面
标准的select语句语法如下:
SELECT [ALL | DISTINCT]
{[<qualifier>.]<column_name> | * | <expression>}
[AS <column_alias>],...
FROM <tablg_or_view_name> | <inline_view> [<table_alias>]
[WHERE <predicate>]
[GROUP BY [<qualifier>.]<column_name>,...
[HAVING <predicate>]]
[ORDER_BY [<qualifier>.]<column_name> | <column_number>
[ASC | DESC],...];