SQL example of order by with manual override of multiple values

For when you want to sort a SQL result set, with a manual override of certain values:

select * from land
order by
  case
  when land = 'Missing data' then '@a'
  when land = 'Not relevant' then '@b'
  else land
  end

Credits goes to Bob Crowley for his article giving the idea to me.

Populære innlegg fra denne bloggen

5 generations of computer languages

DOJO kamptyper [forbedre egen kompetanse]

Generations of text formats