MySQL’s alternative to T-SQL’s WITH TIES

by

Does this work for you?

select Name, Value from table where Value in (
    select distinct Value from table order by Value desc limit 3
) order by Value desc

Or perhaps:

select a.Name, a.Value 
from table a
join (select distinct Value from table order by Value desc limit 3) b
     on a.Value = b.Value

More Related Contents:

  1. You can’t specify target table for update in FROM clause
  2. Generating a range of numbers in MySQL
  3. How to get next/previous record in MySQL?
  4. How do I make a row generator in MySQL?
  5. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  6. MySQL number of items within “in clause”
  7. Error 1046 No database Selected, how to resolve?
  8. What’s the difference between VARCHAR and CHAR?
  9. Alter a MySQL column to be AUTO_INCREMENT
  10. Is there something wrong with joins that don’t use the JOIN keyword in SQL or MySQL?
  11. MySQL ON DUPLICATE KEY UPDATE for multiple rows insert in single query
  12. single fixed table with multiple columns vs flexible abstract tables
  13. MySQL remove duplicates from big database quick
  14. mysql, iterate through column names
  15. How to delete from select in MySQL?
  16. How to delete Duplicates in MySQL table
  17. How to ORDER BY a SUM() in MySQL?
  18. mySQL Returning the top 5 of each category
  19. Selecting Random Rows in MySQL
  20. Error: The used SELECT statements have a different number of columns
  21. Find the number of columns in a table
  22. Mysql, reshape data from long / tall to wide
  23. MySQL: Compare differences between two tables
  24. Mysql strip time component from datetime
  25. How do I start auto increment from a specific point?
  26. What does collation mean?
  27. What’s the correct name for an “association table” (a many-to-many relationship) [closed]
  28. sql pulling a row for next or previous row of a current row
  29. Row Rank in a MySQL View
  30. Select Rows with Maximum Column Value group by Another Column

Leave a Comment