231108 DB - WHERE과 ORDER BY

where절과 order by 절 where절 - 비교연산자 Between A and B 비교연산자 A(하한값) 이상 B(상한값)이하의 값을 비교해주는 연산자로 범위 검색시 활용. 모든 데이터 타입에 활용 가능 -- 숫자형식 : between 하한값 and 상한값 select employee_id, last_name, salary, job_id, department_id from employees where salary between 2500 and 3500; -- 날짜 : between 과거 날짜 and 최근 날짜 select employee_id, last_name, salary, hire_date from employees where hire_date between '1990-01-01' and '.....