SELECT DR_NAME, DR_ID, MCDP_CD, DATE_FORMAT(HIRE_YMD, '%Y-%m-%d')
FROM DOCTOR WHERE MCDP_CD='CS' OR MCDP_CD='GS'
ORDER BY HIRE_YMD DESC, DR_NAME ASC;
DATE_FORMAT(HIRE_YMD, '%Y-%m-%d')
내림차순순 DESC, 오름차순 ASC;
'ㅋㅌ' 카테고리의 다른 글
| 등수 매기기******************* (0) | 2023.08.20 |
|---|---|
| [SQL] JOIN (0) | 2023.08.19 |
| Math.max, Math.abs (0) | 2023.08.14 |
| Math.max (0) | 2023.08.11 |
| replace (0) | 2023.08.07 |