Listing 3: Code That Builds an ORDER BY Clause by Using CASE
SELECT *
FROM OrderTest
ORDER BY
   CASE WHEN template_name = 'generic template' THEN 1 ELSE 0 END,
   template_name