Skip to content
Advertisement

SQL total for each row combination

Are there any types of aggregate functions that could help calculate the following?

If I have the following data, I want the sum total for each duplicated row.

The output would provide total number each row occurs:

Advertisement

Answer

Why not good old group by and count?

User contributions licensed under: CC BY-SA
1 People found this is helpful
Advertisement