The sorting and NULL values page 3 |
||
The fact that NULL-values go first when sorting in ascending order ( 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:
|