Somma dei migliori X risultati HELP

[optime]

SELECT username, SUM(punti)
    FROM (
        SELECT username, punti, ROW_NUMBER() 
          OVER (Partition BY username
                ORDER BY punti DESC ) AS RowNo
        FROM vista
        ) rs WHERE rs.RowNo <= 10        
        GROUP BY username

[informaticaroma]

GRAZIE!!

SELECT username, SUM(punti)
    FROM (
        SELECT username, punti, ROW_NUMBER() 
          OVER (Partition BY username
                ORDER BY punti DESC ) AS RowNo
        FROM vista
        ) rs WHERE rs.RowNo <= 10        
        GROUP BY username