From Crimson Gibbon, 5 Months ago, written in SQL, viewed 59 times.
URL http://codebin.org/view/eedcdc38 Embed
Download Paste or View Raw
  1. SELECT last_name,
  2.     first_name,
  3.     title,
  4.       CASE
  5.           WHEN title LIKE '%IT%' THEN 'разработка'
  6.           WHEN (title LIKE '%Manager%')
  7.               AND (title NOT LIKE '%IT%')  
  8.               THEN 'отдел продаж'
  9.           WHEN title LIKE '%Support%' THEN 'поддержка'
  10.       END
  11. FROM staff;

Reply to "Untitled"

Here you can reply to the paste above