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:
Credits goes to Bob Crowley for his article giving the idea to me.
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.