-
Notifications
You must be signed in to change notification settings - Fork 0
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
[프로그래머스/SQL 고득점 Kit] SELECT #33
Comments
3월에 태어난 여성 회원 목록 출력하기포맷 조심DATE_FORMAT(DATE_OF_BIRTH, '%Y-%m-%d') AS DATE_OF_BIRTH 조건 조심3월에 태어난 여성이므로 아래와 같이 MONTH 함수를 이용하여 해당 달을 찾습니다. MONTH(DATE_OF_BIRTH) = 3 |
sieunnnn
added a commit
that referenced
this issue
Nov 23, 2023
12세 이하인 여자 환자 목록 출력하기값이 NULL 일 경우, 출력 형식 변경하려면IFNULL(TLNO, 'NONE') |
sieunnnn
added a commit
that referenced
this issue
Nov 23, 2023
sieunnnn
added a commit
that referenced
this issue
Nov 23, 2023
sieunnnn
added a commit
that referenced
this issue
Nov 23, 2023
sieunnnn
added a commit
that referenced
this issue
Nov 23, 2023
sieunnnn
added a commit
that referenced
this issue
Nov 23, 2023
상위 n개 레코드만약 정렬 후 특정 개수만 뽑고 싶다면 아래와 같이 사용하면 됩니다. SELECT NAME
FROM ANIMAL_INS
ORDER BY DATETIME
LIMIT 1; |
sieunnnn
added a commit
that referenced
this issue
Nov 24, 2023
sieunnnn
added a commit
that referenced
this issue
Nov 24, 2023
sieunnnn
added a commit
that referenced
this issue
Nov 27, 2023
sieunnnn
added a commit
that referenced
this issue
Nov 27, 2023
sieunnnn
added a commit
that referenced
this issue
Nov 28, 2023
sieunnnn
added a commit
that referenced
this issue
Nov 28, 2023
sieunnnn
added a commit
that referenced
this issue
Dec 7, 2023
sieunnnn
added a commit
that referenced
this issue
Dec 7, 2023
sieunnnn
added a commit
that referenced
this issue
Dec 7, 2023
오프라인/온라인 판매 데이터 통합하기UNION
NULL해당 문제의 경우 오프라인 테이블에는 |
sieunnnn
added a commit
that referenced
this issue
Oct 4, 2024
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
프로그래머스 SQL 고득점 Kit SELECT 문제풀이 입니다.
The text was updated successfully, but these errors were encountered: