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:

Console

Execute

SELECT trip_no, town_from, town_to 
FROM Trip 
ORDER BY NULLIF(town_from,'Rostov'), trip_no;

Pages

SQL Server sorting NULL NULLIF

Previous [Combination of detailed and aggregated data]

[Aggregate function to aggregate function] Next

SQL Problems and solutions

S. I. Moiseenko

SELECT statement

Getting summarizing values

The sorting and NULL values page 3