codice:
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