๐Ÿ“Š

SQL ํฌ๋งคํ„ฐ & ์ •๋ ฌ๊ธฐ SQL Formatter

๋ณต์žกํ•œ ์ฟผ๋ฆฌ๋ฅผ ๊น”๋”ํ•˜๊ฒŒ ๋“ค์—ฌ์“ฐ๊ธฐ ์ •๋ ฌ, ํ‚ค์›Œ๋“œ ๋Œ€์†Œ๋ฌธ์ž ๋ณ€ํ™˜, ๋‹ค์ค‘ DB ๋ฐฉ์–ธ ๋ฐ ํ•œ ์ค„ ์••์ถ•

ํ‚ค์›Œ๋“œ:
๋“ค์—ฌ์“ฐ๊ธฐ:
โœ“์ค€๋น„ ์™„๋ฃŒ. SQL ์ฟผ๋ฆฌ๋ฅผ ์ž…๋ ฅํ•˜์„ธ์š”.
๋ผ์ธ: 0๊ธ€์ž ์ˆ˜: 0๊ตฌ๋ฌธ ์ˆ˜: 0Standard SQL
INPUT์›๋ณธ SQL ์ฟผ๋ฆฌ ์ž…๋ ฅ
๐Ÿ’ก

SQL ์ž‘์„ฑ ๋ฐ ๊ฐ€๋…์„ฑ ํŠœ๋‹ ํ•ต์‹ฌ ๊ฐ€์ด๋“œ

ํ‚ค์›Œ๋“œ ๋Œ€๋ฌธ์ž ํ‘œ์ค€ํ™”

SELECT, FROM, WHERE, JOIN ๋“ฑ ์˜ˆ์•ฝ์–ด๋ฅผ ๋Œ€๋ฌธ์ž๋กœ ํ†ต์ผํ•˜๋ฉด ์‚ฌ์šฉ์ž ์ •์˜ ํ…Œ์ด๋ธ” ๋ฐ ์ปฌ๋Ÿผ ์‹๋ณ„์ž์™€ ํ•œ๋ˆˆ์— ๊ตฌ๋ถ„๋˜์–ด ๊ฐ€๋…์„ฑ์ด ๊ทน๋Œ€ํ™”๋ฉ๋‹ˆ๋‹ค.

์กฐ์ธ(JOIN)๊ณผ ON ์กฐ๊ฑด์‹ ๋ถ„๋ฆฌ

INNER/LEFT JOIN ์ ˆ ๋ฐ”๋กœ ๋‹ค์Œ ์ค„์— ON ๊ฒฐํ•ฉ ์กฐ๊ฑด์„ ๋“ค์—ฌ์“ฐ๊ธฐํ•˜์—ฌ ๋ฐฐ์น˜ํ•˜๋ฉด ์–ด๋–ค ํ‚ค๋กœ ํ…Œ์ด๋ธ”์ด ์—ฐ๊ฒฐ๋˜๋Š”์ง€ ์ง๊ด€์ ์œผ๋กœ ์ถ”์ ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

์„ ํ–‰ ์ฝค๋งˆ(Leading Comma) ์Šคํƒ€์ผ

์ปฌ๋Ÿผ ๋ชฉ๋ก ์•ž์ชฝ์— ์‰ผํ‘œ(, col_name)๋ฅผ ๋ฐฐ์น˜ํ•˜๋ฉด Git ๋ณ€๊ฒฝ์ (Diff) ๋น„๊ต ์‹œ ๋งˆ์ง€๋ง‰ ์ปฌ๋Ÿผ ์ถ”๊ฐ€/์‚ญ์ œ๋กœ ์ธํ•œ ๋ถˆํ•„์š”ํ•œ ์ค„ ๋ณ€๊ฒฝ ์ถฉ๋Œ์„ ๋ฐฉ์ง€ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

๋ณต์žกํ•œ ์ฟผ๋ฆฌ๋Š” CTE (WITH) ํ™œ์šฉ

3๋‹จ๊ณ„ ์ด์ƒ์˜ ๊นŠ์€ ์ค‘์ฒฉ ์„œ๋ธŒ์ฟผ๋ฆฌ๋Š” WITH cte_name AS (...) ์ž„์‹œ ๊ฒฐ๊ณผ ์ง‘ํ•ฉ์œผ๋กœ ์ƒ๋‹จ ๋ถ„๋ฆฌํ•˜๋ฉด ์ฟผ๋ฆฌ ์žฌ์‚ฌ์šฉ์„ฑ๊ณผ ์œ ์ง€๋ณด์ˆ˜์„ฑ์ด ํฌ๊ฒŒ ํ–ฅ์ƒ๋ฉ๋‹ˆ๋‹ค.

๐Ÿ’ฌ

์˜๊ฒฌ ๋ฐ ์งˆ๋ฌธ

0
0 / 1500