Order By Except certain records

by Yugolancer

Posted on Sunday, September 17, 2017

SELECT
   NameEN
FROM
   Country
ORDER BY
  CASE WHEN NameEN = 'Switzerland' THEN 0 ELSE 1 END, NameEN