s02 过滤和排序数据.ppt

Using the WHERE Clause In the example, the SELECT statement retrieves the name, job ID, and department number of all employees whose job ID is SA_REP. Note that the job title SA_REP has been specified in uppercase to ensure that it matches the job ID column in the EMPLOYEES table. Character strings are case sensitive. Character Strings and Dates Character strings and dates in the WHERE clause must be enclosed in single quotation marks (). Number constants, however, should not be enclosed in single quotation marks. All character searches are case sensitive. In the following example, no rows