Counting rows

programming
1

I´ve a little counting-row-problem. This how the SQL Query looks like:


SELECT    dog_id, SUM(points) AS sum
FROM      Protocol AS Protocoll_1
WHERE    (prot_status = 2)
GROUP BY dog_id
ORDER BY sum DESC

Now I just want to add an column with the row number. How to do that?