SQL

From ARtem, 4 Months ago, written in SQL, viewed 70 times.

URL http://codebin.org/view/77312e5a Embed

Download Paste or View Raw

SELECT last_name,
        first_name,
        title,
        CASE 
              WHEN title LIKE '%IT%' THEN 'разработка'
              WHEN title LIKE '%Manager%' AND NOT '%IT%' THEN 'отдел продаж'
              WHEN title LIKE '%Support%' THEN 'поддержка'
         END-- сюда запишите условия
FROM staff;

Reply to "SQL"

Here you can reply to the paste above

Author What's your name?

Title Give your paste a title.

Language What language is your paste written in?

Your paste Paste your paste here

Create Shorturl Create a shorter url that redirects to your paste?

Private Private paste aren't shown in recent listings.

Delete After When should we delete your paste?