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

  • 7
  • 0
  • 约 27页
  • 2016-12-11 发布于重庆
  • 举报

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

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

文档评论(0)

1亿VIP精品文档

相关文档