SQL SERVER - Order By

Question

hi im using sql server 2019 use northwind database I want customers to be sorted by country. With the difference that first it is the United States, Germany and France and then it is an ascending order according to the rest of the countries.

question from:https://stackoverflow.com/questions/65941924/sql-server-order-by

Answer 1

@Gordon's answer will keep mentioned countries in the last.

You need to use case expression as follows:

order by (case when country in ('United States', 'Germany', 'France') then 0
          else 1 
          end),
         country

If you want specific order within the mentioned countries then use multiple when as follows:

order by (case when country = 'United States' then 0
               When country = 'Germany' then 1
               When country = 'France' then 2 
               else 3 
          end),
         country