💻 하나씩 차곡차곡/프로그래머스 (SQL)
[SELECT/LEVEL1] 상위 n개 레코드 (MySQL/Oracle)
뚜루리
2023. 3. 21. 08:41
728x90
320x100
MySQL
SELECT NAME
FROM ANIMAL_INS
ORDER BY DATETIME
LIMIT 1;
Oracle
SELECT NAME
FROM (SELECT * FROM ANIMAL_INS ORDER BY DATETIME)
WHERE ROWNUM = 1;
728x90
320x100