ORACLE_LEVEL_1

Programmers.co.kr 코딩테스트 연습

ORACLE Level 1 모든 문제

최댓값 구하기

SELECT MAX(DATETIME)
FROM ANIMAL_INS;

-Sources :
https://programmers.co.kr/learn/courses/30/lessons/59415

모든 레코드 조회하기

SELECT *
FROM ANIMAL_INS
ORDER BY ANIMAL_ID;

-Sources :
https://programmers.co.kr/learn/courses/30/lessons/59034

역순 정렬하기

SELECT NAME, DATETIME
FROM ANIMAL_INS
ORDER BY ANIMAL_ID DESC;

-Sources :
https://programmers.co.kr/learn/courses/30/lessons/59035

아픈 동물 찾기 - 아프지마

SELECT ANIMAL_ID, NAME
FROM ANIMAL_INS
WHERE INTAKE_CONDITION = 'Sick'
ORDER BY ANIMAL_ID;

-Sources :
https://programmers.co.kr/learn/courses/30/lessons/59036

어린 동물 찾기

SELECT ANIMAL_ID, NAME
FROM ANIMAL_INS
WHERE INTAKE_CONDITION NOT IN('Aged')
ORDER BY ANIMAL_ID;

-Sources :
https://programmers.co.kr/learn/courses/30/lessons/59037

동물의 아이디와 이름

SELECT ANIMAL_ID, NAME
FROM ANIMAL_INS
ORDER BY ANIMAL_ID;

-Sources :
https://programmers.co.kr/learn/courses/30/lessons/59403

여러 기준으로 정렬하기

SELECT ANIMAL_ID, NAME, DATETIME
FROM ANIMAL_INS
ORDER BY NAME ASC, DATETIME DESC;

-Sources :
https://programmers.co.kr/learn/courses/30/lessons/59404

이름이 없는 동물의 아이디

SELECT ANIMAL_ID
FROM ANIMAL_INS
WHERE NAME IS NULL
ORDER BY ANIMAL_ID ASC;

-Sources :
https://programmers.co.kr/learn/courses/30/lessons/59039

이름이 있는 동물의 아이디

SELECT ANIMAL_ID
FROM ANIMAL_INS
WHERE NAME IS NOT NULL
ORDER BY ANIMAL_ID ASC;

-Sources :
https://programmers.co.kr/learn/courses/30/lessons/59407

상위 N개 레코드

SELECT NAME
FROM (
    SELECT RANK() OVER(ORDER BY DATETIME ASC) "RANK", NAME
    FROM ANIMAL_INS
    )
WHERE RANK = 1;

-Sources :
https://programmers.co.kr/learn/courses/30/lessons/59405