데이터베이스/Oracle
2. 오라클 기초 익히기 (WHERE)
왕초보코딩탈출
2018. 2. 18. 16:59
1. 원하는 데이터 조회하기
1 | SELECT First_name, Last_name , DEPARTMENT_ID FROM EMPLOYEES WHERE DEPARTMENT_ID= 60; | cs |
2. BETWEEN 연산자
1 | SELECT First_name, Last_name , SALARY FROM EMPLOYEES WHERE SALARY BETWEEN 5000 AND 10000; | cs |
3. IN연산자
1 | SELECT First_name, Last_name FROM EMPLOYEES WHERE FIRST_NAME IN ('John' , 'Luis'); | cs |
4.
4. LIKE 연산자 (주로 검색에 활용함)
LIKE 연산자에는 % 와 _ 두가지가 있는데
% : 글자수 제한없이 검색
_ : 글자수는 한 글자만 검색
1 | SELECT First_name, Last_name FROM EMPLOYEES WHERE FIRST_NAME LIKE ('A%'); | cs |
1 | SELECT First_name, Last_name FROM EMPLOYEES WHERE FIRST_NAME LIKE ('A__t'); | cs |
5. 여러 검색 조건을 한번에 검색할 때
1 | SELECT First_name, Last_name ,SALARY,DEPARTMENT_ID FROM EMPLOYEES WHERE SALARY > 5000 AND DEPARTMENT_ID= 60; | cs |
6. ORDER BY 절을 이용해 정렬하기
* 문장의 마지막에 작성해야함
디폴트 값은 ASC
ASC (오름차순)
DESC( 내림차순)
1 | SELECT First_name, Last_name , SALARY FROM EMPLOYEES WHERE SALARY > 5000 ORDER BY SALARY DESC; | cs |
