The sorting and NULL values page 3
The fact that NULL-values go first when sorting in ascending order ( SQL(Structured Query Language) is a database computer language designed for the retrieval and management of data in relational database management systems (RDBMS), database schema creation and modification, and database object access control management.SQL Server), we can use in the "useful purposes".
Assume that we need to deduce the list of flights in which flights from Rostov should go first, and then the others in alphabetic order of departure cities.
Here the function NULLIF(town_from,'Rostov'), which will return NULL if city of departure is ' Rostov ', very opportune to be useful.
The problem is being solved with the following query: