Getting and ordering rows with value greater than zero then rows with value zero Getting and ordering rows with value greater than zero then rows with value zero sql sql

Getting and ordering rows with value greater than zero then rows with value zero


mysql sql 

SELECT *FROM atableORDER BY  display_order = 0,  display_order

When display_order is 0, the first sorting term, display_order = 0, evaluates to True, otherwise it evaluates to False. True sorts after False – so, the first sorting criterion makes sure that rows with the display_order of 0 are sorted at the end of the list.

The second ORDER BY term, display_order, additionally specifies the order for rows with the non-zero order values.

Thus, the two criteria give you the desired sorting order.

mysql sql

Try the below one-

SELECT * FROM table_name ORDER BY IF (display_order = 0, 9999999, display_order)

mysql sql

Here is the solution in T-SQL in case anyone needs it

SELECT * FROM Table ORDER BY CASE WHEN display_order = 0 THEN display_order END ASC,CASE WHEN display_order > 0 THEN display_order  END ASC

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last