How do I return rows with a specific value first?

by

On SQL Server, Oracle, DB2, and many other database systems, this is what you can use:

ORDER BY CASE WHEN city = 'New York' THEN 1 ELSE 2 END, city

More Related Contents:

  1. Sort by column ASC, but NULL values first?
  2. SQL multiple column ordering
  3. MySQL: Alternatives to ORDER BY RAND()
  4. PostgreSQL DISTINCT ON with different ORDER BY
  5. ORDER BY the IN value list
  6. SQL best practice to deal with default sort order
  7. How to order by with union in SQL?
  8. SQL Query – Using Order By in UNION
  9. Optimize query with OFFSET on large table
  10. How to use DISTINCT and ORDER BY in same SELECT statement?
  11. sql ORDER BY multiple values in specific order?
  12. Sorting null values after all others, except special
  13. SQL (ORACLE): ORDER BY and LIMIT [duplicate]
  14. How to use SQL Order By statement to sort results case insensitive?
  15. Can I do a max(count(*)) in SQL?
  16. How to update and order by using ms sql
  17. SQL Server UNION – What is the default ORDER BY Behaviour
  18. Sort NULL values to the end of a table
  19. PostgreSQL ORDER BY issue – natural sort
  20. Why do NULL values come first when ordering DESC in a PostgreSQL query?
  21. Alphanumeric sorting with PostgreSQL
  22. Sorting string column containing numbers in SQL?
  23. “Order By” using a parameter for the column name
  24. Custom Order in Oracle SQL
  25. SQL for ordering by number – 1,2,3,4 etc instead of 1,10,11,12
  26. SQLite Order By Date1530019888000
  27. how does SELECT TOP works when no order by is specified?
  28. SQL ORDER chars numerically
  29. Dynamic order direction
  30. Curious issue with Oracle UNION and ORDER BY

Leave a Comment