mardi 5 mai 2015

SQL 2008: get distinct values in a table

I have a small temp table with 2 columns: ErrorName and Value.

ErrorName|Value
---------|-----
Error1   |3
Error2   |2
Error3   |2
Error1   |1
Error2   |1

I want to sum up the value field based on the ErrorName and return something like this:

Error1   |4
Error2   |3
Error3   |2

Aucun commentaire:

Enregistrer un commentaire