What is the best way to generate ranks in MYSQL?

by

This will return the students’ rank, student ID, and GPA.

set @rownum := 0;
SELECT @rownum := @rownum + 1 AS rank, student_id, gpa 
    FROM `students` ORDER BY gpa DESC

More Related Contents:

  1. Join vs. sub-query
  2. Find records from one table which don’t exist in another
  3. How do I update if exists, insert if not (AKA “upsert” or “merge”) in MySQL?
  4. Natural Sort in MySQL
  5. MySQL get row position in ORDER BY
  6. Comparing date ranges
  7. Subqueries vs joins
  8. MySQL Results as comma separated list
  9. MySQL unknown column in ON clause
  10. MySQL not using indexes with WHERE IN clause?
  11. SQL: Find the max record per group [duplicate]
  12. Group by month and year in MySQL
  13. calculate a sum of type time using sql
  14. MySQL: Transactions vs Locking Tables
  15. MySQL: What is a reverse version of LIKE?
  16. Remove duplicates using only a MySQL query?
  17. Group by date only on a Datetime column
  18. Finding the next available id in MySQL
  19. How exactly does using OR in a MySQL statement differ with/without parentheses?
  20. MySQL: How to copy rows, but change a few fields?
  21. How to renumber primary index
  22. Query that ignore the spaces
  23. MySQL select where column is not empty
  24. Is it possible to have a default parameter for a mysql stored procedure?
  25. mysql automatically store record creation timestamp
  26. update columns values with column of another table based on condition [duplicate]
  27. MySQL GROUP BY behavior
  28. Update multiple rows with one query?
  29. I want to copy table contained from one database and insert onto another database table
  30. How do MySQL views work?

Leave a Comment