-
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] String, Date #45
Comments
sieunnnn
added a commit
that referenced
this issue
Dec 20, 2023
sieunnnn
added a commit
that referenced
this issue
Dec 20, 2023
sieunnnn
added a commit
that referenced
this issue
Dec 20, 2023
sieunnnn
added a commit
that referenced
this issue
Dec 20, 2023
sieunnnn
added a commit
that referenced
this issue
Jan 8, 2024
sieunnnn
added a commit
that referenced
this issue
Jan 8, 2024
sieunnnn
added a commit
that referenced
this issue
Jan 8, 2024
자동차 평균 대여 기간 구하기날짜 기간 구하기DATEDIFF(end_date, start_date) |
sieunnnn
added a commit
that referenced
this issue
Jan 8, 2024
sieunnnn
added a commit
that referenced
this issue
Jan 8, 2024
sieunnnn
added a commit
that referenced
this issue
Jan 8, 2024
중성화 여부 파악하기IF (첫번째 조건 OR 두번째 조건, 첫번째 조건의 결과, 두번째 조건의 결과) |
sieunnnn
added a commit
that referenced
this issue
Jan 9, 2024
sieunnnn
added a commit
that referenced
this issue
Jan 9, 2024
sieunnnn
added a commit
that referenced
this issue
Jan 9, 2024
조회수가 가장 많은 중고거래 게시판의 첨부파일 조회하기CONCAT()문자열을 합칠 때 사용합니다. CONCAT('/home/grep/src/', F.BOARD_ID, '/', F.FILE_ID, F.FILE_NAME, F.FILE_EXT) AS FILE_PATH 처음 작성한 방식SELECT CONCAT('/home/grep/src/', F.BOARD_ID, "/",F.FILE_ID,F.FILE_NAME, F.FILE_EXT) AS FILE_PATH
FROM USED_GOODS_BOARD AS B
JOIN USED_GOODS_FILE AS F
ON B.BOARD_ID = F.BOARD_ID
ORDER BY VIEWS DESC LIMIT 1;
|
sieunnnn
added a commit
that referenced
this issue
Jan 9, 2024
sieunnnn
added a commit
that referenced
this issue
Jan 10, 2024
sieunnnn
added a commit
that referenced
this issue
Jan 10, 2024
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
프로그래머스 SQL 고득점 Kit String, Date 문제풀이 입니다.
The text was updated successfully, but these errors were encountered: