【文件属性】:
文件名称:运用WHERE子句-SQL语言基础
文件大小:5.26MB
文件格式:PPT
更新时间:2021-04-25 19:38:09
SQL 基础
运用WHERE子句
*
SQL> SELECT ename, job, deptno
2 FROM emp
3 WHERE job='CLERK';
ENAME JOB DEPTNO
---------- --------- ---------
JAMES CLERK 30
SMITH CLERK 20
ADAMS CLERK 20
MILLER CLERK 10
*
SELECT ename, job, deptno
FROM emp
WHERE job='CLERK';
Using the WHERE Clause
In the example, the SELECT statement retrieves the name, job title, and department number of all employees whose job title is CLERK.
Note that the job title CLERK has been specified in uppercase to ensure that the match is made with the job column in the EMP table. Character strings are case sensitive.
Instructor Note
Snippet: “Processing a Query”