HI

I have a table in which the serial numbers and the totals are being repeated . I want to get the count of distinct rows as well as the total of those rows.

Let me know how can i write it

eg

SNO TOTAL

1 10
1 10
2 5
3 10
3 10

i want distinct count fo rows and total for them is same
SQL

answer I am expecting in this case is

3 25

let me know