--!sql
 
-- [en] IF - ELSE condition in ibm db2
-- [pl] warunek IF - ELSE w bazie db2
 
SELECT
   name
 , salary
 , CASE 
      WHEN 
         salary > 10000 
      THEN 
         'Management'
      ELSE 
         'Programmer'
   END AS position
FROM company
ORDER BY salary