์—ฐ์‚ฐ์ž ์šฐ์„ ์ˆœ์œ„ 1
[SQL] WHERE ์ ˆ

1. WHERE ์ ˆ - ๋ฐ์ดํ„ฐ๋ฅผ ์กฐํšŒํ•  ๋•Œ ํŠน์ • ์กฐ๊ฑด์„ ๊ธฐ์ค€์œผ๋กœ ์›ํ•˜๋Š” ํ–‰์„ ์ถœ๋ ฅํ•˜๋Š” ๋ฐ ์‚ฌ์šฉ SELECT [์กฐํšŒํ•  ์นผ๋Ÿผ 1 ์ด๋ฆ„], [์นผ๋Ÿผ 2 ์ด๋ฆ„], … , [์นผ๋Ÿผ N ์ด๋ฆ„] FROM [์กฐํšŒํ•  ํ…Œ์ด๋ธ” ์ด๋ฆ„] WHERE[์กฐํšŒํ•  ์นผ๋Ÿผ์„ ์„ ๋ณ„ํ•˜๊ธฐ ์œ„ํ•œ ์กฐ๊ฑด์‹]; -- ์กฐ๊ฑด์‹์˜ ๊ฒฐ๊ณผ๊ฐ€ ์ฐธ์ธ ์นผ๋Ÿผ๋งŒ ์ถœ๋ ฅ SELECT * FROM EMP WHERE DEPTNO = 30; - WHERE์ ˆ์ด ํฌํ•จ๋œ SELECT๋ฌธ์„ ์‹คํ–‰ํ•˜๋ฉด ์กฐํšŒํ•  ํ…Œ์ด๋ธ”์˜ ๊ฐ ์นผ๋Ÿผ์— WHERE์ ˆ์˜ ์กฐ๊ฑด์‹์„ ๋Œ€์ž…ํ•˜์—ฌ ๊ฒฐ๊ณผ๊ฐ€ ์ฐธ์ธ ์นผ๋Ÿผ๋งŒ ์ถœ๋ ฅ 2. ๋…ผ๋ฆฌ ์—ฐ์‚ฐ์ž AND , OR - WHERE์ ˆ์—์„œ ์กฐ๊ฑด์‹์„ ์—ฌ๋Ÿฌ ๊ฐœ ์ €์žฅํ•˜๊ธฐ ์œ„ํ•ด ์‚ฌ์šฉํ•˜๋Š” ๋…ผ๋ฆฌ ์—ฐ์‚ฐ์ž AND, OR -- 1. AND SELECT * FROM EMP WHERE DEPTNO = 30 AND ..
ํ”„๋กœ๊ทธ๋ž˜๋ฐ ์–ธ์–ด/DataBase 2021.02.20
1
๋”๋ณด๊ธฐ

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