Define the order by with NULL value in MySQL
Arrange the order of Null value in MySQL as follows:
Show the NULL value in last position in Mysql
SELECT * from employees order by country is null, country asc;
Show NULL value in first position in MySQL
SELECT * FROM EMPLOYEES ORDER BY country is not null, country desc;
Related