I have got a MySql query that orders me results by no
column (int, can be null).
Simple example:
SELECT * FROM table ORDER BY no ASC
I would like to get a resultset sorted like
1, 2, 3, 10, 52, 66, NULL, NULL, NULL
but I get
NULL, NULL, NULL, 1, 2, 3, 10, 52, 66
Is it possible with SQL query ?
Could you try this?
ORDER BY ISNULL(no),no;
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With