songining
article thumbnail
๊ณผ๋ชฉII SQL ๊ธฐ๋ณธ ๋ฐ ํ™œ์šฉ 1์žฅ - 5์ ˆ/6์ ˆ WHERE์ ˆ, FUNCTION
SQLD 2021. 5. 21. 20:35

5์ ˆ. WHERE์ ˆ WHERE์ ˆ ์—ฐ์‚ฐ์ž (SQL ์—ฐ์‚ฐ์ž) -BETWEEN A AND B ( NOT BETWEEN A AND B) -IN (list) ( NOT IN (list)) -LIKE '๋น„๊ต๋ฌธ์ž์—ด' -IS NULL ( IS NOT NULL) WHERE ์กฐ๊ฑด - CHAR ๋ณ€์ˆ˜๋‚˜ VARCHAR2 ๊ฐ™์€ ๋ฌธ์žํ˜• ํƒ€์ž…์„ ๊ฐ€์ง„ ์นผ๋Ÿผ์€ ์ธ์šฉ๋ถ€ํ˜ธ(์ž‘์€ ๋”ฐ์˜ดํ‘œ, ํฐ ๋”ฐ์˜ดํ‘œ)๋กœ ๋ฌถ์–ด์„œ ๋น„๊ต - LIKE EX) SELECT PLAYER_NAME ์„ ์ˆ˜์ด๋ฆ„ , POSITION ํฌ์ง€์…˜ , BACK_NO ๋ฐฑ๋„˜๋ฒ„ , HEIGHT ํ‚ค FROM PLAYER WHERE PLAYER_NAME LIKE '์žฅ%'; % : 0๊ฐœ์ด์ƒ์˜ ๋ฌธ์ž _ : 1๊ฐœ์ด์ƒ์˜ ๋‹จ์ผ ๋ฌธ์ž - NULL : ์•„์ง ์ •์˜๋˜์ง€ ์•Š์€ ๋ฏธ์ง€์˜ ๊ฐ’, '', 0 ๊ณผ๋Š” ๋‹ค๋ฅธ ๊ฐ’..