文件名称：运用WHERE子句-SQL语言基础
文件大小：5.26MB
文件格式：PPT
更新时间：2024-05-15 13:24:49
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”