How to get a ranking result for special record in mysql [closed]

by

You want to get the rank in MySQL. Here is one approach:

SELECT id, name, @rn := @rn+1 as `rank`
from `users` cross join (select @rn := 0) const
ORDER BY points desc

More Related Contents:

  1. left join query keep a column empty
  2. How to do a regular expression replace in MySQL?
  3. Rank function in MySQL
  4. Count the number of occurrences of a string in a VARCHAR field?
  5. MySQL 8.0 – Client does not support authentication protocol requested by server; consider upgrading MySQL client
  6. Can’t connect to MySQL server error 111 [closed]
  7. How to import a CSV file into a MySQL table
  8. How to store arrays in MySQL?
  9. Include headers when using SELECT INTO OUTFILE?
  10. ERROR 1130 (HY000): Host ” is not allowed to connect to this MySQL server [duplicate]
  11. How do I select between the 1st day of the current month and current day in MySQL?
  12. Subqueries with EXISTS vs IN – MySQL
  13. MySQL timezone change?
  14. Cronjob or MySQL event?
  15. How to insert BLOB and CLOB files in MySQL?
  16. 60 million entries, select entries from a certain month. How to optimize database?
  17. How to start spring-boot app without depending on Database?
  18. Is it possible to GROUP BY multiple columns using MySQL?
  19. MySQL compare DATE string with string from DATETIME field
  20. MySQL monthly Sale of last 12 months including months with no Sale
  21. Can MySQL FIND_IN_SET or equivalent be made to use indices?
  22. How to fuzzy match email or telephone by Elasticsearch?
  23. How can I use transactions in my MySQL stored procedure?
  24. MySQL: LAST_INSERT_ID() returns 0
  25. MySQL – select data from database between two dates
  26. Calculating a Moving Average MySQL?
  27. What are the optimum varchar sizes for MySQL?
  28. Can MySQL use multiple indexes for a single query?
  29. ERROR 1044 (42000): Access denied for ‘root’ With All Privileges
  30. Does replace into have a where clause?

Leave a Comment