SQL 새로운 문법을 깨닫다!(조건절에서 !의 사용)

in #sql8 years ago

문제: 사원번호가 7654와 7782사이 이외인 사원의 모든 정보출력

내가 쓰던 기존방법1.
SELECT *
FROM emp
WHERE empno NOT IN(
....SELECT empno
....FROM emp
....WHERE empno >= 7654
....AND empno <= 7782);

내가 쓰던 기존방법2.
SELECT *
FROM emp
WHERE empno <7654
OR empno > 7782;

새로 깨달은 방법3.
SELECT *
FROM emp
WHERE !(empno >= 7654
AND empno <= 7782);

WHERE절 전체에 !연산자를 적용할수 있다는걸 깨달았습니다
까먹지 말아야지..

Sort:  

Congratulations @flyhamster! You received a personal award!

Happy Birthday! - You are on the Steem blockchain for 1 year!

You can view your badges on your Steem Board and compare to others on the Steem Ranking

Do not miss the last post from @steemitboard:

The Steem community has lost an epic member! Farewell @woflhart!
SteemitBoard - Witness Update
Do not miss the coming Rocky Mountain Steem Meetup and get a new community badge!
Vote for @Steemitboard as a witness to get one more award and increased upvotes!

Coin Marketplace

STEEM 0.05
TRX 0.32
JST 0.082
BTC 64963.37
ETH 1757.42
USDT 1.00
SBD 0.42