Home
๋‚ด๊ฐ€ ํ•จ๊ป˜ํ•  ํšŒ์‚ฌ๋ฅผ ์„ ํƒํ•œ ๊ธฐ์ค€
๐Ÿ–ฅ๏ธ

SQL

MOD

MOD๋Š” ์ฒซ ๋ฒˆ์งธ ์ธ์ž๋ฅผ ๋‘ ๋ฒˆ์งธ ์ธ์ž๋กœ ๋‚˜๋ˆˆ ๋‚˜๋จธ์ง€๋ฅผ ๋ฐ˜ํ™˜
์ง์ˆ˜์ธ ๊ฒƒ ๊ฐ€์ ธ์˜ฌ ๋•Œ
MOD(id, 2)=0

GROUP BY

ํŠน์ • ์ปฌ๋Ÿผ์˜ ์ค‘๋ณต์„ ์ œ๊ฑฐํ•จ

<>

๋‹ค๋ฅด๋‹ค

LIKE

๋น„์Šทํ•œ ๊ฑธ ์ฐพ์•„์™€๋ผ

%

like์™€ ํ•จ๊ป˜ ์“ฐ๋Š”๋ฐ, ๋ฌด์—‡์ด๋“  ์ƒ๊ด€ ์—†์„ ๋•Œ
LIKE โ€˜%rโ€™
LIKE โ€˜r%โ€™
LIKE โ€˜%r%โ€™
wildcard๋ผ๊ณ ๋„ ๋ถ€๋ฆ„

_

LIKE โ€˜B_____โ€™
โ†’ B๋กœ ์‹œ์ž‘ํ•œ ๋’ค์— ๋‹ค์„ฏ ๊ฐœ์˜ ๋ฌธ์ž๊ฐ€ ๋”ฐ๋ผ์˜ค๋Š” ๊ฒƒ ์ฐพ๊ธฐ
wildcard์ด์ง€๋งŒ ๊ธ€์ž ์ˆ˜ ์ •ํ•ด์ค„ ์ˆ˜ ์žˆ์Œ

\

์—ญ์Šฌ๋ž˜์‹œ backslash
%๋ผ๋Š” ๋ฌธ์ž๊ฐ€ ๋“ค์–ด๊ฐ€ ์žˆ๋Š” ๊ฑธ ์ฐพ๊ณ  ์‹ถ์„ ๋•Œ
์ด์Šค์ผ€์ดํ”„. ์˜ˆ์•ฝ์–ด ํƒˆ์ถœ.
LIKE โ€˜__\%โ€™

IN

WHERE country = โ€˜Germanyโ€™ OR country = โ€˜Franceโ€™
WHERE country IN (โ€™Germanyโ€™, โ€˜Franceโ€™)

BETWEEN

WHERE CustomerID BETWEEN 3 AND 5

IS NULL

=์„ ๋ถ™์ด๋ฉด ์•ˆ ๋‚˜์˜จ๋‹ค.
CustomerID IS NULL
NaN๋„ ์‚ฌ์šฉ ๊ฐ€๋Šฅ

IS NOT NULL

LEFT, RIGHT

SELECT LEFT(โ€20140323โ€,4) โ‡’ 2014

SUBSTRING

SUBSTR(โ€20140323โ€,1,3) โ†’ 2014
SUBSTR(โ€20140323, 5) โ†’ 0323
โ€ข
์‹œ์ž‘์œ„์น˜๋งŒ ์“ฐ๊ณ  ๊ธธ์ด ์•ˆ ์“ฐ๋ฉด ๋ชจ๋‘ ๊ฐ€์ ธ์˜จ๋‹ค.

์˜ฌ๋ฆผ/๋‚ด๋ฆผ/๋ฐ˜์˜ฌ๋ฆผ

CEIL ์˜ฌ๋ฆผ
FLOOR ๋‚ด๋ฆผ
ROUND ๋ฐ˜์˜ฌ๋ฆผ
โ€ข
ROUND(5.556901, 4)
โ—ฆ
๋„ท์งธ์ž๋ฆฌ๊นŒ์ง€ ํ‘œ๊ธฐํ•œ๋‹ค๋Š” ๋œป

์ตœ๋Œ“๊ฐ’, ์ตœ์†Ÿ๊ฐ’

DESC ๋˜๋Š” ASC์™€ LIMIT์„ ํ•จ๊ป˜ ์‚ฌ์šฉํ•˜๋ฉด ๋œ๋‹ค.