haju__log
[lv.2] 3월에 태어난 여성 회원 목록 출력하기 본문
반응형
SELECT MEMBER_ID,MEMBER_NAME,GENDER,DATE_FORMAT(DATE_OF_BIRTH,"%Y-%m-%d") AS "DATE_OF_BIRTH"
FROM MEMBER_PROFILE
WHERE TLNO IS NOT NULL AND GENDER ='W' AND DATE_OF_BIRTH LIKE '%-03-%'
ORDER BY MEMBER_ID ASC;
반응형