Fórum Função CASE Simples e CASE Pesquisada #496900

--CASE Simples
SELECT LAST_NAME, HIRE_DATE, 
       TRUNC(MONTHS_BETWEEN(SYSDATE,HIRE_DATE)/12) YEARS,
       TRUNC(MONTHS_BETWEEN(SYSDATE,HIRE_DATE)/60) "YEARS DIVIDED BY 5",
       CASE TRUNC(MONTHS_BETWEEN(SYSDATE,HIRE_DATE) / 60)
         WHEN 0 THEN 'Intern'
         WHEN 1 THEN 'Junior'
         WHEN 2 THEN 'Intermediate'
         WHEN 3 THEN 'Senior'
         ELSE 'Furniture'
       END LOYALTY
FROM EMPLOYEES
WHERE DEPARTMENT_ID IN (60,10);

--CASE Pesquisada
SELECT LAST_NAME, HIRE_DATE, 
      TRUNC(MONTHS_BETWEEN(SYSDATE,HIRE_DATE)/12) YEARS,
      TRUNC(MONTHS_BETWEEN(SYSDATE,HIRE_DATE)/60) YEARS,
      CASE
        WHEN TRUNC(MONTHS_BETWEEN(SYSDATE,HIRE_DATE)/60) < 1 THEN 'Intern'
        WHEN TRUNC(MONTHS_BETWEEN(SYSDATE,HIRE_DATE)/60) < 2 THEN 'Intern'
        WHEN TRUNC(MONTHS_BETWEEN(SYSDATE,HIRE_DATE)/60) < 3 THEN 'Intern'
        WHEN TRUNC(MONTHS_BETWEEN(SYSDATE,HIRE_DATE)/60) < 4 THEN 'Intern'
        ELSE 'Furniture'
      END LOYALTY
FROM EMPLOYEES
WHERE DEPARTMENT_ID IN (60,10);