Banner

My Tech Blog (์ž๋™์ฐจ๋ฆฌ์ŠคํŠธ๊ตฌํ•˜๊ธฐ)

์˜ค๋Š˜์˜ ๋ช…์–ธ
" ๋‚˜๋Š” ํŠน๋ณ„ํ•œ ์žฌ๋Šฅ์ด ์žˆ๋Š” ๊ฒƒ์ด ์•„๋‹ˆ๋‹ค. ๋‹จ์ง€ ์—ด์ •์ ์œผ๋กœ ํ˜ธ๊ธฐ์‹ฌ์„ ๊ฐ€์งˆ ๋ฟ์ด๋‹ค. "
- ์•จ๋ฒ„ํŠธ ์•„์ธ์Šˆํƒ€์ธ (์ด๋ก  ๋ฌผ๋ฆฌํ•™์ž)
[ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค] (MySQL) ๋Œ€์—ฌ ๊ธฐ๋ก์ด ์กด์žฌํ•˜๋Š” ์ž๋™์ฐจ ๋ฆฌ์ŠคํŠธ ๊ตฌํ•˜๊ธฐ
ยท Algorithm/SQLํ…Œ์ŠคํŠธ
๐Ÿ“‘ 1. ๋ฌธ์ œ์„ค๋ช…โŒ 2. ์‹คํŒจํ•œ ์‹œ๋„์ฝ”๋“œ๋Š” ์ž‘๋™ํ•˜์ง€๋งŒ ์ •๋‹ต ์ฒ˜๋ฆฌ X์ด์œ : CAR_ID ์ค‘๋ณต๋จSELECT A.Car_idFROM Car_rental_company_car A JOIN Car_rental_company_rental_history B ON A.Car_id = B.Car_idWHERE A.Car_type = '์„ธ๋‹จ' AND B.Start_date BETWEEN '2022-10-01' AND '2022-10-31'ORDER BY A.Car_id DESC;โญ 3. ์ •๋‹ต์ฝ”๋“œCAR_ID ์ค‘๋ณต์ด ์—†์–ด์•ผ ํ•˜๋ฉฐ -> DISTINCT๋Œ€์—ฌ ๊ธฐ๋ก์ด ์žˆ๋Š” -> ON A.CAR_ID = B.CAR_IDSELECT DISTINCT(A.Car_id)FROM ..
์ƒ๋‹จ์œผ๋กœ

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