코딩할 때 심경변화가 딱 저렇다 고민 > 어디서 틀렸는지 모름 > 찾음 > 갑자기 기분좋음 # 집합연산자 # UNION SELECT JOB_ID FROM EMPLOYEES WHERE 1=1 AND SALARY BETWEEN 2000 AND 5000 ORDER BY JOB_ID; SELECT JOB_ID FROM EMPLOYEES WHERE 1=1 AND SALARY BETWEEN 2000 AND 5000 GROUP BY JOB_ID ORDER BY JOB_ID; SELECT DISTINCT JOB_ID FROM EMPLOYEES WHERE 1=1 AND SALARY BETWEEN 2000 AND 5000 ORDER BY JOB_ID; SELECT JOB_ID FROM EMPLOYEES WHERE 1=1 AND SALARY BETWEEN 5001 AND 6000 ORDER BY JOB_ID; SELECT JOB_ID FROM EMPLOYEES WHERE 1=1 AND SALARY BE...
#
1일1코딩
#
unionall
#
where
#
그로스마케팅
#
그로스해킹
#
데이터분석
#
데이터분석가
#
복습
#
연습문제
#
집합연산자
#
취업
#
커리어전환
#
코딩
#
union
#
sql
#
20대
#
30대
#
covid19
#
distinct
#
from
#
groupby
#
intersect
#
minus
#
orderby
#
python
#
R
#
select
#
파이썬
원문 링크 : SQL 코딩 복습_210208_STEP4 (2)
