问个SQL Query# Database - 数据库m*o2008-04-07 07:041 楼column1 column2 column3a b 2a c 4b d 9a c 7Query以后,把column1和column2完全相同的行输出,并把column3的结果相加:a c 11
B*g2008-04-07 07:042 楼your homework?http://www.w3schools.com/sql/sql_groupby.asp【在 m*******o 的大作中提到】: column1 column2 column3: a b 2: a c 4: b d 9: a c 7: Query以后,把column1和column2完全相同的行输出,并把column3的结果相加:: a c 11
M*n2008-04-07 07:043 楼select column1,column2,sum(column3) from table_name group by column1,column2 having count(*)>1;【在 m*******o 的大作中提到】: column1 column2 column3: a b 2: a c 4: b d 9: a c 7: Query以后,把column1和column2完全相同的行输出,并把column3的结果相加:: a c 11