๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ
728x90

sql5

[SQL] CASE Statement (MySQL) โ€ป ๋ฌธ์ œ ํ’€์ด๋ฅผ ํ•˜๋ฉด์„œ SQL ๋ณต์Šต ์ •๋ฆฌ โ€ป ๐Ÿ“– ์ฐธ๊ณ  ๋ฐ ๊ณต์‹๋ฌธ์„œ CASE๋ฌธ https://dev.mysql.com/doc/refman/8.0/en/case.html MySQL :: MySQL 8.0 Reference Manual :: 15.6.5.1 CASE Statement CASE case_value WHEN when_value THEN statement_list [WHEN when_value THEN statement_list] ... [ELSE statement_list] END CASE Or: CASE WHEN search_condition THEN statement_list [WHEN search_condition THEN statement_list] ... [ELSE statement_li.. 2024. 2. 6.
[Programmers] ์ž๋™์ฐจ ์ข…๋ฅ˜ ๋ณ„ ํŠน์ • ์˜ต์…˜์ด ํฌํ•จ๋œ ์ž๋™์ฐจ ์ˆ˜ ๊ตฌํ•˜๊ธฐ (MySQL) https://school.programmers.co.kr/learn/courses/30/lessons/151137 ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค ์ฝ”๋“œ ์ค‘์‹ฌ์˜ ๊ฐœ๋ฐœ์ž ์ฑ„์šฉ. ์Šคํƒ ๊ธฐ๋ฐ˜์˜ ํฌ์ง€์…˜ ๋งค์นญ. ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค์˜ ๊ฐœ๋ฐœ์ž ๋งž์ถคํ˜• ํ”„๋กœํ•„์„ ๋“ฑ๋กํ•˜๊ณ , ๋‚˜์™€ ๊ธฐ์ˆ  ๊ถํ•ฉ์ด ์ž˜ ๋งž๋Š” ๊ธฐ์—…๋“ค์„ ๋งค์นญ ๋ฐ›์œผ์„ธ์š”. programmers.co.kr ๐Ÿ—’๏ธ ERD โœ๏ธ ์ œ์ถœ ์ •๋‹ต ์ฝ”๋“œ SELECT CAR_TYPE, COUNT(*) AS CARS FROM CAR_RENTAL_COMPANY_CAR WHERE OPTIONS LIKE '%ํ†ตํ’์‹œํŠธ%' OR OPTIONS LIKE '%์—ด์„ ์‹œํŠธ%' OR OPTIONS LIKE '%๊ฐ€์ฃฝ์‹œํŠธ%' GROUP BY CAR_TYPE ORDER BY CAR_TYPE; ๐Ÿ“Œ SQL๋ฌธ ์ •๋ฆฌ 1. ๋…ผ๋ฆฌ ์—ฐ์‚ฐ์ž Name D.. 2024. 1. 6.
[SQL] Aggregate & Mathematical Function ์ •๋ฆฌ (MySQL) โ€ป ๋ฌธ์ œ ํ’€์ด๋ฅผ ํ•˜๋ฉด์„œ SQL ๋ณต์Šต ์ •๋ฆฌ โ€ป ๐Ÿ“– ์ฐธ๊ณ  ๋ฐ ๊ณต์‹๋ฌธ์„œ ์ง‘๊ณ„ํ•จ์ˆ˜ https://dev.mysql.com/doc/refman/8.0/en/aggregate-functions.html MySQL :: MySQL 8.0 Reference Manual :: 12.19.1 Aggregate Function Descriptions MySQL 8.0 Reference Manual / ... / Functions and Operators / Aggregate Functions / Aggregate Function Descriptions 12.19.1 Aggregate Function Descriptions This section describes aggregate functions that operate o.. 2024. 1. 3.
[Programmers] ์ž๋™์ฐจ ๋Œ€์—ฌ ๊ธฐ๋ก์—์„œ ์žฅ๊ธฐ/๋‹จ๊ธฐ ๋Œ€์—ฌ ๊ตฌ๋ถ„ํ•˜๊ธฐ (MySQL) https://school.programmers.co.kr/learn/courses/30/lessons/151138 ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค ์ฝ”๋“œ ์ค‘์‹ฌ์˜ ๊ฐœ๋ฐœ์ž ์ฑ„์šฉ. ์Šคํƒ ๊ธฐ๋ฐ˜์˜ ํฌ์ง€์…˜ ๋งค์นญ. ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค์˜ ๊ฐœ๋ฐœ์ž ๋งž์ถคํ˜• ํ”„๋กœํ•„์„ ๋“ฑ๋กํ•˜๊ณ , ๋‚˜์™€ ๊ธฐ์ˆ  ๊ถํ•ฉ์ด ์ž˜ ๋งž๋Š” ๊ธฐ์—…๋“ค์„ ๋งค์นญ ๋ฐ›์œผ์„ธ์š”. programmers.co.kr ๐Ÿ—’๏ธ ERD โœ๏ธ ์ œ์ถœ ์ •๋‹ต ์ฝ”๋“œ SELECT HISTORY_ID, CAR_ID, DATE_FORMAT(START_DATE, '%Y-%m-%d') AS START_DATE, DATE_FORMAT(END_DATE, '%Y-%m-%d') AS END_DATE, IF (DATEDIFF(END_DATE, START_DATE) >= 29, '์žฅ๊ธฐ ๋Œ€์—ฌ', '๋‹จ๊ธฐ ๋Œ€์—ฌ') AS RENT_TYPE FROM .. 2023. 12. 29.
[Programmers] ํŠน์ • ์˜ต์…˜์ด ํฌํ•จ๋œ ์ž๋™์ฐจ ๋ฆฌ์ŠคํŠธ ๊ตฌํ•˜๊ธฐ (MySQL) https://school.programmers.co.kr/learn/courses/30/lessons/157343 ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค ์ฝ”๋“œ ์ค‘์‹ฌ์˜ ๊ฐœ๋ฐœ์ž ์ฑ„์šฉ. ์Šคํƒ ๊ธฐ๋ฐ˜์˜ ํฌ์ง€์…˜ ๋งค์นญ. ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค์˜ ๊ฐœ๋ฐœ์ž ๋งž์ถคํ˜• ํ”„๋กœํ•„์„ ๋“ฑ๋กํ•˜๊ณ , ๋‚˜์™€ ๊ธฐ์ˆ  ๊ถํ•ฉ์ด ์ž˜ ๋งž๋Š” ๊ธฐ์—…๋“ค์„ ๋งค์นญ ๋ฐ›์œผ์„ธ์š”. programmers.co.kr ๐Ÿ—’๏ธ ERD โœ๏ธ ์ œ์ถœ ์ •๋‹ต ์ฝ”๋“œ SELECT CAR_ID, CAR_TYPE, DAILY_FEE, OPTIONS FROM CAR_RENTAL_COMPANY_CAR WHERE OPTIONS LIKE '%๋„ค๋น„๊ฒŒ์ด์…˜%' ORDER BY CAR_ID DESC; ๐Ÿ“Œ SQL๋ฌธ ์ •๋ฆฌ String Comparison https://soo-note.tistory.com/110 [SQL] ๋ฌธ์ž์—ด ๋น„๊ตํ•จ์ˆ˜ ์•Œ์•„๋ณด๊ธฐ.. 2023. 12. 21.
728x90

ํ‹ฐ์Šคํ† ๋ฆฌํˆด๋ฐ”