From ARtem, 4 Months ago, written in SQL, viewed 70 times.
URL http://codebin.org/view/77312e5a 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%' AND NOT '%IT%' THEN 'отдел продаж'
  7.               WHEN title LIKE '%Support%' THEN 'поддержка'
  8.          END-- сюда запишите условия
  9. FROM staff;

Reply to "SQL"

Here you can reply to the paste above