- 1、本文档共32页,可阅读全部内容。
- 2、原创力文档(book118)网站文档一经付费(服务费),不意味着购买了该文档的版权,仅供个人/单位学习、研究之用,不得用于商业用途,未经授权,严禁复制、发行、汇编、翻译或者网络传播等,侵权必究。
- 3、本站所有内容均由合作方或网友上传,本站不对文档的完整性、权威性及其观点立场正确性做任何保证或承诺!文档内容仅供研究参考,付费前请自行鉴别。如您付费,意味着您自己接受本站规则且自行承担风险,本站不退款、不进行额外附加服务;查看《如何避免下载的几个坑》。如果您已付费下载过本站文档,您可以点击 这里二次下载。
- 4、如文档侵犯商业秘密、侵犯著作权、侵犯人身权等,请点击“版权申诉”(推荐),也可以打举报电话:400-050-0827(电话支持时间:9:00-18:30)。
查看更多
Les02 Restricting and Sorting Data
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 Using Comparison Conditions Other Comparison Conditions Using the BETWEEN Condition Use the BETWEEN condition to display rows based on a range of values. Using the IN Condition Use the IN membership condition to test for values in a list. Using the LIKE Condition Use the LIKE condition to perform wildcard searches of valid search string values. Search conditions can contain either literal characters or numbers: % denotes zero or many characters. _ denotes one character. Using the LIKE Condition You can combine pattern-matching characters. You can use the ESCAPE identifier to search for the actual % and _ symbols. Using the NULL Conditions Test for nulls with the IS NULL operator. Logical Conditions Using the AND Operator Using the OR Operator Using the NOT Operator Rules of Precedence Rules of Precedence Rules of Precedence ORDER BY Clause Sort rows with the ORDER BY clause ASC: ascending order, default DESC: descending order The ORDER BY clause comes last in the SELECT statement. Sorting in Descending Order Sorting by Column Alias Sorting by Multiple Columns The order of ORDER BY list is the order of sort. You can sort by a column that is not in the SELECT list. Summary Practice 2 Overview This practice covers the following topics: Selecting data and changing the order ofrows displayed Restricting rows by using the WHERE clause Sorting rows by using the ORDER
您可能关注的文档
- CentOS 安装 LimeSurvey 系统.doc
- CFX13_08_Transient.ppt
- Ch0101市场营销导论.ppt
- ch3.1_Transform-Domain Representation of Discrete-Time Signals.ppt
- ch2 Transaction Analysis.ppt
- ch9. transaction.ppt
- Changjiang River1.ppt
- Chap8Chapter 8 The Discrete Fourier Transform (DFT).doc
- Chap008__Management of Transaction Exposure.ppt
- Chapter 10 Game theory.ppt
- 初中数学人教版八年级上册课件 13.1.1 轴对称.pptx
- 1.1细胞是生命活动的基本单位(教学课件)-高中生物学人教版(2019)必修一.pptx
- 基因控制生物的性状课件人教版初中生物八年级下册.pptx
- 人教版八年级上册 What's the best movie theater?Section A Grammar 课件(共21张PPT).pptx
- 人教版数学八年级上册12.2.1 用“SSS”判定三角形全等课件(共26张PPT).pptx
- 17.1勾股定理 课件(共17张PPT)人教版初中数学八年级下册.pptx
- 等腰三角形课件人教版八年级数学上册.pptx
- 23.1图形的旋转课件+2024-2025学年人教版数学九年级上册.pptx
- 九年级数学人教版----(上册)24.1.1 圆.pptx
- 初中数学人教版九年级上册24.1.3 弧、弦、圆心角课件(27张PPT).pptx
文档评论(0)