请教：sql 语法问题

[dangchen]

sql= "select distinctrow sum(selection1) AS sum_selection1, "
sql= sql & "sum(selection2) AS sum_selection2, sum(selection3) AS sum_selection3,sum(selection4 ) AS sum_selection4, "
sql= sql & "sum(selection5) AS sum_selection5, count(*) AS total_votes "
sql= sql & "FROM VOTE;"
以上代码错在那？有什么语法错误？小虾等候大侠的赐教。
在线等。给100分

[yzllfcn]

在这里要去掉row,并且因为你取的都是和，所以distinct在这里也是没什么用的，可要可不要。
如
sql= "select distinct sum(selection1) AS sum_selection1, "
sql= sql & "sum(selection2) AS sum_selection2, sum(selection3) AS sum_selection3,sum(selection4 ) AS sum_selection4, "
sql= sql & "sum(selection5) AS sum_selection5, count(*) AS total_votes "
sql= sql & "FROM VOTE;"

[gdos]

sql= "select sum(selection1) AS sum_selection1, "
sql= sql & "sum(selection2) AS sum_selection2, sum(selection3) AS sum_selection3,sum(selection4 ) AS sum_selection4, "
sql= sql & "sum(selection5) AS sum_selection5, count(*) AS total_votes "
sql= sql & "FROM VOTE;"

[snowcloud2002]

up