https://www.hackerrank.com/challenges/salary-of-employees/problem?isFullScreen=true
코드설명
SELECT + ORDER BY 를 활용합니다.
ORACLE 코드
SELECT NAME
FROM EMPLOYEE
WHERE SALARY > 2000
AND MONTHS < 10
ORDER BY EMPLOYEE_ID ASC;
'SQL > HackerRank' 카테고리의 다른 글
[SQL][HackerRank] The PADS - UNION + ORDER BY + STRING || ORACLE (0) | 2024.10.01 |
---|---|
[SQL][HackerRank] Employee Names - CASE WHEN ORACLE (0) | 2024.09.30 |
[SQL][HackerRank] Employee Names - SELECT + ORDER BY ORACLE (0) | 2024.09.30 |
[SQL][HackerRank] Higher Than 75 Marks - SUBSTR + LENGTH ORACLE (0) | 2024.09.28 |
[SQL][HackerRank] Weather Observation Station 12 - REGEXP_LIKE + NOT ORACLE (0) | 2024.09.28 |