💻 하나씩 차곡차곡/프로그래머스 (SQL)
[SELECT/LEVEL1] 흉부외과 또는 일반외과 의사 목록 출력하기 (MySQL/Oracle)
뚜루리
2023. 4. 3. 07:46
728x90
320x100
MySQL
SELECT DR_NAME
, DR_ID
, MCDP_CD
, DATE_FORMAT(HIRE_YMD, '%Y-%m-%d') AS HIRE_YMD
FROM DOCTOR
WHERE MCDP_CD IN ('CS', 'GS')
ORDER BY HIRE_YMD DESC, DR_NAME
Oracle
SELECT DR_NAME
, DR_ID
, MCDP_CD
, TO_CHAR(HIRE_YMD,'YYYY-MM-DD')
FROM DOCTOR
WHERE MCDP_CD IN ('CS', 'GS')
ORDER BY HIRE_YMD DESC, DR_NAME;
728x90
320x100