Java课件第22讲SQL语言高级02条件查询和排序.pptVIP

Restricting and Sorting Data Objectives After completing this lesson, you should be able to do the following: Limit the rows retrieved by a query Sort the rows retrieved by a query Limiting Rows Using a Selection Limiting the Rows Selected Restrict the rows returned by using the WHERE clause. The WHERE clause follows the FROM clause. Using the WHERE Clause Character Strings and Dates Character strings and date values are enclosed in single quotation marks. Character values are case sensitive, and date values are format sensitive. The default date format is DD-MON-RR. Comparison Conditions