본문 바로가기
Programming/SQL

[프로그래머스] 3월에 태어난 여성 회원 목록 출력하기

by 왕밤빵도라에몽 2025. 4. 3.
728x90
SELECT
    MEMBER_ID,
    MEMBER_NAME,
    GENDER,
    DATE_FORMAT(DATE_OF_BIRTH, '%Y-%m-%d')
        AS DATE_OF_BIRT
FROM MEMBER_PROFILE
WHERE
    MONTH(DATE_OF_BIRTH) = 3
    AND GENDER = 'W'
    AND TLNO IS NOT NULL
ORDER BY MEMBER_ID
  • is not null로 null값 제외 출력 가능
728x90