In SQL, how to select the top 2 rows for each group

by 
SELECT *
FROM   test s
WHERE 
        (
            SELECT  COUNT(*) 
            FROM    test  f
            WHERE f.name = s.name AND 
                  f.score >= s.score
        ) <= 2

More Related Contents:

  1. Using LIMIT within GROUP BY to get N results per group?
  2. Retrieving the last record in each group – MySQL
  3. Using ORDER BY and GROUP BY together
  4. ROW_NUMBER() in MySQL
  5. Get top n records for each group of grouped results
  6. Group by clause in mySQL and postgreSQL, why the error in postgreSQL?
  7. Strange duplicate behavior from GROUP_CONCAT of two LEFT JOINs of GROUP_BYs
  8. What’s faster, SELECT DISTINCT or GROUP BY in MySQL?
  9. Select row with most recent date per user
  10. Mysql query to dynamically convert rows to columns
  11. MySQL “Group By” and “Order By”
  12. SELECT / GROUP BY – segments of time (10 seconds, 30 seconds, etc)
  13. Group mysql query by 15 min intervals
  14. Get the latest date from grouped MySQL data
  15. How to get the latest record in each group using GROUP BY? [duplicate]
  16. SQL Query to get column values that correspond with MAX value of another column?
  17. MySQL Group By and Sum total value of other column
  18. Get most recent row for given ID
  19. Is it possible to GROUP BY multiple columns using MySQL?
  20. Using Count to find the number of occurrences
  21. How to select the most recent set of dated records from a mysql table
  22. MySQL: How do I join same table multiple times?
  23. GROUP BY – do not group NULL
  24. Selecting all corresponding fields using MAX and GROUP BY
  25. SELECT query return 1 row from each group
  26. MySQL SELECT most frequent by group
  27. MySQL Group By Hours
  28. mysql count group by having
  29. How do I limit the number of rows per field value in SQL?
  30. SQL query with avg and group by

Leave a Comment