In modern DBMS like Oracle, PostgreSQL, DB2, Firebird, Apache Derby, HSQLDB , H2, etc. you can specify NULLS LAST or NULLS FIRST in a select statement.
Used when you required sorted data in output having required column contains NULL values in it. It shows NULL values per below clauses.
NULLS LAST - To sort data in which NULLS are showing in the last records.
NULLS FIRST - To sort data to the beginning - Default clause of a sql select statement.
select * from emp order by emp_name DESC NULLS LAST;
select * from emp order by emp_name DESC NULLS FIRST;
Used when you required sorted data in output having required column contains NULL values in it. It shows NULL values per below clauses.
NULLS LAST - To sort data in which NULLS are showing in the last records.
NULLS FIRST - To sort data to the beginning - Default clause of a sql select statement.
select * from emp order by emp_name DESC NULLS LAST;
select * from emp order by emp_name DESC NULLS FIRST;
