Shulou(Shulou.com)05/31 Report--

This article is about how to use the where clause in Oracle. Xiaobian thinks it is quite practical, so share it with everyone for reference. Let's follow Xiaobian and have a look.

Query employee information of department 20 in emp table

select * from emp where deptno = 20;

Query employees whose name is SMITH, string uses '', content case sensitive

select * from emp where ename = 'SMITH';

Summary: Which of the techniques you have studied are case sensitive and which are case insensitive

Query employees who joined on December 17, 1980. Note oracle default date format (DD-MON-RR indicates 2-digit year)

select * from emp where hiredate = '17-December-80';

Query employees whose salary is greater than 1500

select * from emp where sal > 1500;

Query employees whose salary is not equal to 1500 [!= or

select * from emp where sal 1500;

Query employees with salaries between 1300 and 1600, including 1300 and 1600 [between applies to numbers]

select * from emp where (sal>=1300) and (sal

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.