SQL 새로운 문법을 깨닫다!(조건절에서 !의 사용)
문제: 사원번호가 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절 전체에 !연산자를 적용할수 있다는걸 깨달았습니다
까먹지 말아야지..
Congratulations @flyhamster! You received a personal award!
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:
Vote for @Steemitboard as a witness to get one more award and increased upvotes!