<html xmlns="http://www.w3.org/1999/xhtml"><head><meta charset="utf-8"><meta name="generator" content="pdf2htmlEX"><meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1"><link rel="stylesheet" href="https://csdnimg.cn/release/download_crawler_static/css/base.min.css"><link rel="stylesheet" href="https://csdnimg.cn/release/download_crawler_static/css/fancy.min.css"><link rel="stylesheet" href="https://csdnimg.cn/release/download_crawler_static/3262951/raw.css"><script src="https://csdnimg.cn/release/download_crawler_static/js/compatibility.min.js"></script><script src="https://csdnimg.cn/release/download_crawler_static/js/pdf2htmlEX.min.js"></script><script>try{pdf2htmlEX.defaultViewer = new pdf2htmlEX.Viewer({});}catch(e){}</script><title></title></head><body><div id="sidebar" style="display: none"><div id="outline"></div></div><div id="pf1" class="pf w0 h0" data-page-no="1"><div class="pc pc1 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://csdnimg.cn/release/download_crawler_static/3262951/bg1.jpg"><div class="t m0 x1 h2 y1 ff1 fs0 fc0 sc0 ls0 ws0">Introduction to Oracle9<span class="ff2 ls1 ws1">i</span><span class="ls2 ws2">: SQL</span></div><div class="t m0 x1 h3 y2 ff1 fs1 fc0 sc0 ls3 ws3">Student Guide <span class="ls4 ws4">• <span class="ls5 ws5">Volume 1</span></span></div><div class="t m0 x2 h4 y3 ff3 fs1 fc0 sc0 ls6 ws1">40049GC10</div><div class="t m0 x2 h4 y4 ff3 fs1 fc0 sc0 ls6 ws6">Production 1.0</div><div class="t m0 x2 h4 y5 ff3 fs1 fc0 sc0 ls7 ws7">June 2001</div><div class="t m0 x2 h4 y6 ff3 fs1 fc0 sc0 ls8 ws1">D33051</div></div><div class="pi" data-data='{"ctm":[1.568627,0.000000,0.000000,1.568627,0.000000,0.000000]}'></div></div></body></html>
<div id="pf2" class="pf w0 h0" data-page-no="2"><div class="pc pc2 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://csdnimg.cn/release/download_crawler_static/3262951/bg2.jpg"><div class="t m0 x3 h5 y7 ff1 fs2 fc0 sc0 ls9 ws8">Copyright © Oracle Corporation, 2000, 2001. All rights reserved.</div><div class="t m0 x3 h6 y8 ff3 fs2 fc0 sc0 lsa ws9">This documentation contains proprietary information of Oracle Co<span class="lsb wsa">rporation. It is </span></div><div class="t m0 x3 h6 y9 ff3 fs2 fc0 sc0 lsc wsb">provided under a license agreement containing restrictions on us<span class="lsd wsc">e and disclosure and </span></div><div class="t m0 x3 h6 ya ff3 fs2 fc0 sc0 lse wsd">is also protected by copyright law. Reverse engineering of the s<span class="lsf wse">oftware is prohibited. </span></div><div class="t m0 x3 h6 yb ff3 fs2 fc0 sc0 ls10 wsf">If this documentation is delivered to a U.S. Government Agency o<span class="ls11 ws10">f the Department of </span></div><div class="t m0 x3 h6 yc ff3 fs2 fc0 sc0 ls12 ws11">Defense, then it is delivered with Restricted Rights and the fol<span class="ls13 ws12">lowing legend is </span></div><div class="t m0 x3 h6 yd ff3 fs2 fc0 sc0 ls14 ws1">applicable:</div><div class="t m0 x3 h5 ye ff1 fs2 fc0 sc0 ls15 ws13">Restricted Rights Legend</div><div class="t m0 x3 h6 yf ff3 fs2 fc0 sc0 ls9 ws14">Use, duplication or disclosure by the Government is subject to r<span class="ls16 ws15">estrictions for </span></div><div class="t m0 x3 h6 y10 ff3 fs2 fc0 sc0 ls17 ws16">commercial computer software and shall be deemed to be Restricte<span class="ls18 ws17">d Rights software </span></div><div class="t m0 x3 h6 y11 ff3 fs2 fc0 sc0 ls19 ws18">under Federal law, as set forth in subparagraph (c)(1)(ii) of DF<span class="ls1a ws19">ARS 252.227<span class="ls1b ws1">-<span class="ls1c ws1a">7013, </span></span></span></div><div class="t m0 x3 h6 y12 ff3 fs2 fc0 sc0 ls15 ws1b">Rights in Technical Data and Computer Software (October 1988).</div><div class="t m0 x3 h6 y13 ff3 fs2 fc0 sc0 ls1d ws1c">This material or any portion of it may not be copied in any form<span class="_"> </span><span class="ls1e ws1d">or by any means </span></div><div class="t m0 x3 h6 y14 ff3 fs2 fc0 sc0 ls1f ws1e">without the express prior written permission of Oracle Corporati<span class="ls20 ws1f">on. Any other copying </span></div><div class="t m0 x3 h6 y15 ff3 fs2 fc0 sc0 ls21 ws20">is a violation of copyright law and may result in civil and/or c<span class="ls22 ws21">riminal penalties.</span></div><div class="t m0 x3 h6 y16 ff3 fs2 fc0 sc0 ls10 wsf">If this documentation is delivered to a U.S. Government Agency n<span class="ls23 ws22">ot within the </span></div><div class="t m0 x3 h6 y17 ff3 fs2 fc0 sc0 ls24 ws23">Department of Defense, then it is delivered with <span class="ls25 ws1">“<span class="ls26 ws24">Restricted Rig</span><span class="ls27">hts,</span><span class="ws25">” <span class="ls22 wsd">as defined in </span></span></span></div><div class="t m0 x3 h6 y18 ff3 fs2 fc0 sc0 ls22 ws26">FAR 52.227<span class="ls1b ws1">-<span class="ls28 ws27">14, Rights in Data</span>-<span class="ls21 ws20">General, including Alternate III (June 1987).</span></span></div><div class="t m0 x3 h6 y19 ff3 fs2 fc0 sc0 ls29 ws28">The information in this document is subject to change without no<span class="ls2a ws29">tice. If you find any </span></div><div class="t m0 x3 h6 y1a ff3 fs2 fc0 sc0 ls8 ws1c">problems in the documentation, please report them in writing to <span class="ls2b ws2a">Education Products, </span></div><div class="t m0 x3 h6 y1b ff3 fs2 fc0 sc0 ls2c ws2b">Oracle Corporation, 500 Oracle Parkway, Box SB<span class="ls1b ws1">-<span class="ls2d ws2c">6, Redwood Shores, CA 94065. </span></span></div><div class="t m0 x3 h6 y1c ff3 fs2 fc0 sc0 ls2e ws2d">Oracle Corporation does not warrant that this document is error<span class="ls1b ws1">-<span class="ls2f">free.</span></span></div><div class="t m0 x3 h6 y1d ff3 fs2 fc0 sc0 ls30 ws2e">Oracle and all references to Oracle products are trademarks or r<span class="ls31 ws2f">egistered trademarks </span></div><div class="t m0 x3 h6 y1e ff3 fs2 fc0 sc0 ls32 ws30">of Oracle Corporation.</div><div class="t m0 x3 h6 y1f ff3 fs2 fc0 sc0 ls33 ws31">All other products or company names are used for identification <span class="ls34 ws32">purposes only, and </span></div><div class="t m0 x3 h6 y20 ff3 fs2 fc0 sc0 ls35 ws33">may be trademarks of their respective owners.</div><div class="t m0 x4 h7 y21 ff4 fs3 fc0 sc0 lsc ws1">Authors</div><div class="t m0 x4 h8 y22 ff5 fs1 fc0 sc0 ls36 ws34">Nancy Greenberg</div><div class="t m0 x4 h8 y23 ff5 fs1 fc0 sc0 ls37 ws1">Priya<span class="_"> </span><span class="ls38 ws35">Nathan </span></div><div class="t m0 x4 h7 y24 ff4 fs3 fc0 sc0 ls39 ws36">Technical Contributors</div><div class="t m0 x4 h7 y25 ff4 fs3 fc0 sc0 ls3a ws37">and Reviewers</div><div class="t m0 x4 h8 y26 ff5 fs1 fc0 sc0 ls3b ws38">Josephine Turner</div><div class="t m0 x4 h8 y27 ff5 fs1 fc0 sc0 ls3c ws39">Anna Atkinson</div><div class="t m0 x4 h8 y28 ff5 fs1 fc0 sc0 lsc ws3a">Don Bates</div><div class="t m0 x4 h8 y29 ff5 fs1 fc0 sc0 ls3d ws1">Marco<span class="_"> </span><span class="ls3e">Berbeek</span></div><div class="t m0 x4 h8 y2a ff5 fs1 fc0 sc0 ls3f ws1">Andrew<span class="_"> </span><span class="ls40">Brannigan</span></div><div class="t m0 x4 h8 y2b ff5 fs1 fc0 sc0 ls41 ws1">Michael<span class="_"> </span><span class="ls42">Gerlach</span></div><div class="t m0 x4 h8 y2c ff5 fs1 fc0 sc0 ls43 ws3b">Sharon Gray</div><div class="t m0 x4 h8 y2d ff5 fs1 fc0 sc0 ls44 ws3c">Rosita Hanoman</div><div class="t m0 x4 h8 y2e ff5 fs1 fc0 sc0 ls45 ws3d">Mozhe Jalali</div><div class="t m0 x4 h8 y2f ff5 fs1 fc0 sc0 ls46 ws3e">Sarah Jones</div><div class="t m0 x4 h8 y30 ff5 fs1 fc0 sc0 ls47 ws3f">Charbel Khouri</div><div class="t m0 x4 h8 y31 ff5 fs1 fc0 sc0 ls48 ws40">Christopher Lawless</div><div class="t m0 x4 h8 y32 ff5 fs1 fc0 sc0 ls49 ws1">Diana<span class="_"> </span><span class="ls4a">Lorentz</span></div><div class="t m0 x4 h8 y33 ff5 fs1 fc0 sc0 ls4b ws1">Nina<span class="_"> </span><span class="ls4c">Minchen</span></div><div class="t m0 x4 h8 y34 ff5 fs1 fc0 sc0 ls4d ws1">Cuong<span class="_"> </span><span class="ls4e">Nguyen</span></div><div class="t m0 x4 h8 y35 ff5 fs1 fc0 sc0 ls4f ws1">Daphne<span class="_"> </span><span class="ls50">Nougier</span></div><div class="t m0 x4 h8 y36 ff5 fs1 fc0 sc0 ls51 ws41">Patrick Odell</div><div class="t m0 x4 h8 y37 ff5 fs1 fc0 sc0 ls52 ws1">Laura<span class="_"> </span><span class="ls53">Pezzini</span></div><div class="t m0 x4 h8 y38 ff5 fs1 fc0 sc0 ls54 ws42">Stacey Procter</div><div class="t m0 x4 h8 y39 ff5 fs1 fc0 sc0 ls55 ws43">Maribel Renau</div><div class="t m0 x4 h8 y3a ff5 fs1 fc0 sc0 ls56 ws44">Bryan Roberts</div><div class="t m0 x4 h8 y3b ff5 fs1 fc0 sc0 ls57 ws45">Sunshine Salmon</div><div class="t m0 x4 h8 y3c ff5 fs1 fc0 sc0 ls58 ws1">Casa<span class="_"> </span><span class="ls40">Sharif</span></div><div class="t m0 x4 h8 y3d ff5 fs1 fc0 sc0 ls45 ws1">Bernard<span class="_"> </span><span class="ls59">Soleillant</span></div><div class="t m0 x4 h8 y3e ff5 fs1 fc0 sc0 ls5a ws46">Ruediger Steffan</div><div class="t m0 x4 h8 y3f ff5 fs1 fc0 sc0 ls5b ws1">Karla<span class="_"> </span><span class="ls5c">Villasenor</span></div><div class="t m0 x4 h8 y40 ff5 fs1 fc0 sc0 ls5d ws47">Andree Wheeley</div><div class="t m0 x4 h8 y41 ff5 fs1 fc0 sc0 ls5e ws48">Lachlan Williams</div><div class="t m0 x4 h7 y42 ff4 fs3 fc0 sc0 ls5f ws1">Publisher</div><div class="t m0 x4 h9 y43 ff5 fs3 fc0 sc0 ls60 ws49">Sheryl Domingue</div></div><div class="pi" data-data='{"ctm":[1.568627,0.000000,0.000000,1.568627,0.000000,0.000000]}'></div></div>
<div id="pf3" class="pf w0 h0" data-page-no="3"><div class="pc pc3 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://csdnimg.cn/release/download_crawler_static/3262951/bg3.jpg"><div class="t m0 x5 ha y44 ff1 fs4 fc0 sc0 ls61 ws1">Preface</div><div class="t m0 x5 ha y45 ff1 fs4 fc0 sc0 ls62 ws4a">Curriculum Map</div><div class="t m0 x6 hb y46 ff1 fs3 fc0 sc0 ls63 ws1">Introduction</div><div class="t m0 x6 hc y47 ff3 fs3 fc0 sc0 ls64 ws4b">Objectives I<span class="ls65 ws1">-<span class="ls66">2</span></span></div><div class="t m0 x6 hd y48 ff3 fs3 fc0 sc0 ls67 ws1">Oracle9<span class="ff6 ls5 ws4c">i <span class="_ _0"> </span></span><span class="ls5">I<span class="ls65">-<span class="ls66">3</span></span></span></div><div class="t m0 x6 hd y49 ff3 fs3 fc0 sc0 ls67 ws1">Oracle9<span class="ff6 ls5 ws4c">i </span><span class="ls68 ws4d">Application Server I</span><span class="ls65">-<span class="ls66">5</span></span></div><div class="t m0 x6 hd y4a ff3 fs3 fc0 sc0 ls67 ws1">Oracle9<span class="ff6 ls5">i<span class="_"> </span></span><span class="ls69 ws4e">Database I</span><span class="ls65">-<span class="ls66">6</span></span></div><div class="t m0 x6 hd y4b ff3 fs3 fc0 sc0 ls67 ws1">Oracle9<span class="ff6 ls5">i</span><span class="ls6a ws4f">: Object Relational Database Management System I</span><span class="ls65">-<span class="ls66">8</span></span></div><div class="t m0 x6 hc y4c ff3 fs3 fc0 sc0 ls6b ws50">Oracle Internet Platform I<span class="ls65 ws1">-<span class="ls66">9</span></span></div><div class="t m0 x6 hc y4d ff3 fs3 fc0 sc0 ls69 ws35">System Development Life Cycle I<span class="ls65 ws1">-<span class="ls66">10</span></span></div><div class="t m0 x6 hc y4e ff3 fs3 fc0 sc0 ls6c ws51">Data Storage on Different Media I<span class="_ _1"></span><span class="ls65 ws1">-<span class="ls66">12</span></span></div><div class="t m0 x6 hc y4f ff3 fs3 fc0 sc0 ls6d ws52">Relational Database Concept I<span class="ls65 ws1">-<span class="ls66">13</span></span></div><div class="t m0 x6 hc y50 ff3 fs3 fc0 sc0 ls6e ws53">Definition of a Relational Database I<span class="_ _1"></span><span class="ls65 ws1">-<span class="ls66">14</span></span></div><div class="t m0 x6 hc y38 ff3 fs3 fc0 sc0 ls6f ws54">Data Models I<span class="ls65 ws1">-<span class="ls66">15</span></span></div><div class="t m0 x6 hc y51 ff3 fs3 fc0 sc0 ls70 ws55">Entity Relationship Model I<span class="_ _1"></span><span class="ls65 ws1">-<span class="ls66">16</span></span></div><div class="t m0 x6 hc y52 ff3 fs3 fc0 sc0 ls71 ws56">Entity Relationship Modeling Conventions I<span class="_ _1"></span><span class="ls65 ws1">-<span class="ls66">17</span></span></div><div class="t m0 x6 hc y53 ff3 fs3 fc0 sc0 ls72 ws57">Relating Multiple Tables I<span class="ls65 ws1">-<span class="ls66">19</span></span></div><div class="t m0 x6 hc y54 ff3 fs3 fc0 sc0 ls73 ws58">Relational Database Terminology I<span class="ls65 ws1">-<span class="ls66">20</span></span></div><div class="t m0 x6 hc y55 ff3 fs3 fc0 sc0 ls22 ws59">Relational Database Properties I<span class="ls65 ws1">-<span class="ls66">21</span></span></div><div class="t m0 x6 hc y56 ff3 fs3 fc0 sc0 ls74 ws5a">Communicating with a RDBMS Using SQL I<span class="ls65 ws1">-<span class="ls66">22</span></span></div><div class="t m0 x6 hc y57 ff3 fs3 fc0 sc0 ls75 ws5b">Relational Database Management System I<span class="ls65 ws1">-<span class="ls66">23</span></span></div><div class="t m0 x6 hc y58 ff3 fs3 fc0 sc0 ls76 ws5c">SQL Statements I<span class="ls65 ws1">-<span class="ls66">24</span></span></div><div class="t m0 x6 hc y59 ff3 fs3 fc0 sc0 ls77 ws5d">Tables Used in the Course I<span class="ls65 ws1">-<span class="ls66">25</span></span></div><div class="t m0 x6 hc y5a ff3 fs3 fc0 sc0 ls78 ws5e">Summary I<span class="ls65 ws1">-<span class="ls66">26</span></span></div><div class="t m0 x5 hb y5b ff1 fs3 fc0 sc0 ls64 ws1">1<span class="_ _2"> </span><span class="ls79">Writing Basic SQL SELECT Statements</span></div><div class="t m0 x6 hc y5c ff3 fs3 fc0 sc0 ls7a ws5f">Objectives 1<span class="ls65 ws1">-<span class="ls66">2</span></span></div><div class="t m0 x6 hc y5d ff3 fs3 fc0 sc0 ls7b ws60">Capabilities of SQL SELECT Statements 1<span class="ls65 ws1">-<span class="ls66">3</span></span></div><div class="t m0 x6 hc y5e ff3 fs3 fc0 sc0 ls7c ws61">Basic SELECT Statement 1<span class="ls65 ws1">-<span class="ls66">4</span></span></div><div class="t m0 x7 ha y5f ff1 fs4 fc0 sc0 ls32 ws1">Contents</div><div class="t m0 x8 h3 y60 ff1 fs1 fc0 sc0 ls7d ws1">iii</div></div><div class="pi" data-data='{"ctm":[1.568627,0.000000,0.000000,1.568627,0.000000,0.000000]}'></div></div>
<div id="pf4" class="pf w0 h0" data-page-no="4"><div class="pc pc4 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://csdnimg.cn/release/download_crawler_static/3262951/bg4.jpg"><div class="t m0 x6 hc y61 ff3 fs3 fc0 sc0 ls7e ws62">Selecting All Columns 1<span class="ls65 ws1">-<span class="ls66">5</span></span></div><div class="t m0 x6 hc y62 ff3 fs3 fc0 sc0 ls7f ws63">Selecting Specific Columns 1<span class="ls65 ws1">-<span class="ls66">6</span></span></div><div class="t m0 x6 hc y63 ff3 fs3 fc0 sc0 ls80 ws64">Writing SQL Statements 1<span class="ls65 ws1">-<span class="ls66">7</span></span></div><div class="t m0 x6 hc y64 ff3 fs3 fc0 sc0 ls81 ws65">Column Heading Defaults 1<span class="ls65 ws1">-<span class="ls66">8</span></span></div><div class="t m0 x6 hc y65 ff3 fs3 fc0 sc0 ls82 ws66">Arithmetic Expressions 1<span class="_ _3"></span><span class="ls65 ws1">-<span class="ls66">9</span></span></div><div class="t m0 x6 hc y66 ff3 fs3 fc0 sc0 ls83 ws67">Using Arithmetic Operators 1<span class="ls65 ws1">-<span class="ls66">10</span></span></div><div class="t m0 x6 hc y67 ff3 fs3 fc0 sc0 ls84 ws68">Operator Precedence 1<span class="ls65 ws1">-<span class="ls66">11</span></span></div><div class="t m0 x6 hc y68 ff3 fs3 fc0 sc0 ls85 ws69">Using Parentheses 1<span class="ls65 ws1">-<span class="ls86">13</span></span></div><div class="t m0 x6 hc y69 ff3 fs3 fc0 sc0 ls87 ws6a">Defining a Null Value 1<span class="_ _1"></span><span class="ls65 ws1">-<span class="ls66">14</span></span></div><div class="t m0 x6 hc y6a ff3 fs3 fc0 sc0 ls22 ws6b">Null Values in Arithmetic Expressions 1<span class="_ _3"></span><span class="ls65 ws1">-<span class="ls66">15</span></span></div><div class="t m0 x6 hc y6b ff3 fs3 fc0 sc0 ls7a ws6c">Defining a Column Alias 1<span class="ls65 ws1">-<span class="ls66">16</span></span></div><div class="t m0 x6 hc y6c ff3 fs3 fc0 sc0 ls88 ws6d">Using Column Aliases 1<span class="ls65 ws1">-<span class="ls66">17</span></span></div><div class="t m0 x6 hc y6d ff3 fs3 fc0 sc0 ls89 ws6e">Concatenation Operator 1<span class="ls65 ws1">-<span class="ls66">18</span></span></div><div class="t m0 x6 hc y6e ff3 fs3 fc0 sc0 ls8a ws6f">Using the Concatenation Operator 1<span class="_ _1"></span><span class="ls65 ws1">-<span class="ls66">19</span></span></div><div class="t m0 x6 hc y6f ff3 fs3 fc0 sc0 ls8b ws70">Literal Character Strings 1<span class="_ _1"></span><span class="ls65 ws1">-<span class="ls66">20</span></span></div><div class="t m0 x6 hc y70 ff3 fs3 fc0 sc0 ls8c ws71">Using Literal Character Strings 1<span class="_ _1"></span><span class="ls65 ws1">-<span class="ls66">21</span></span></div><div class="t m0 x6 hc y71 ff3 fs3 fc0 sc0 ls8d ws72">Duplicate Rows 1<span class="ls65 ws1">-<span class="ls66">22</span></span></div><div class="t m0 x6 hc y72 ff3 fs3 fc0 sc0 ls8e ws73">Eliminating Duplicate Rows 1<span class="ls65 ws1">-<span class="ls66">23</span></span></div><div class="t m0 x6 hc y73 ff3 fs3 fc0 sc0 ls8f ws74">SQL and<span class="_"> </span><span class="ls66 ws1">iSQL<span class="ls79 ws75">*Plus Interaction 1</span><span class="ls65">-</span>24</span></div><div class="t m0 x6 hc y74 ff3 fs3 fc0 sc0 ls90 ws76">SQL Statements versus<span class="_ _0"> </span><span class="ls66 ws1">iSQL<span class="ls7 ws77">*Plus Commands 1<span class="_ _3"></span><span class="ls65 ws1">-<span class="ls66">25</span></span></span></span></div><div class="t m0 x6 hc y75 ff3 fs3 fc0 sc0 lsc ws78">Overview of<span class="_"> </span><span class="ls66 ws1">iSQL<span class="ls91 ws79">*Plus 1</span><span class="ls65">-</span>26</span></div><div class="t m0 x6 hc y76 ff3 fs3 fc0 sc0 ls92 ws7a">Logging In to<span class="_ _4"> </span><span class="ls66 ws1">iSQL<span class="ls91 ws7b">*Plus 1</span><span class="ls65">-</span>27</span></div><div class="t m0 x6 hc y77 ff3 fs3 fc0 sc0 ls93 ws1">The<span class="_"> </span><span class="ls66">iSQL<span class="ls94 ws7c">*Plus Environment 1</span><span class="ls65">-</span>28</span></div><div class="t m0 x6 hc y78 ff3 fs3 fc0 sc0 ls22 ws7d">Displaying Table Structure 1<span class="_ _1"></span><span class="ls65 ws1">-<span class="ls66">29</span></span></div><div class="t m0 x6 hc y79 ff3 fs3 fc0 sc0 ls95 ws7e">Interacting with Script Files 1<span class="_ _1"></span><span class="ls65 ws1">-<span class="ls66">31</span></span></div><div class="t m0 x6 hc y7a ff3 fs3 fc0 sc0 ls96 ws7f">Summary 1<span class="ls65 ws1">-<span class="ls66">34</span></span></div><div class="t m0 x6 hc y7b ff3 fs3 fc0 sc0 ls87 ws80">Practice 1 Overview 1<span class="ls65 ws1">-<span class="ls86">35</span></span></div><div class="t m0 x8 h3 y60 ff1 fs1 fc0 sc0 ls97 ws1">iv</div></div><div class="pi" data-data='{"ctm":[1.568627,0.000000,0.000000,1.568627,0.000000,0.000000]}'></div></div>
<div id="pf5" class="pf w0 h0" data-page-no="5"><div class="pc pc5 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://csdnimg.cn/release/download_crawler_static/3262951/bg5.jpg"><div class="t m0 x5 hb y7c ff1 fs3 fc0 sc0 ls64 ws1">2<span class="_ _2"> </span><span class="ls98 ws36">Restricting and Sorting Data</span></div><div class="t m0 x6 hc y7d ff3 fs3 fc0 sc0 ls7a ws5f">Objectives 2<span class="ls65 ws1">-<span class="ls66">2</span></span></div><div class="t m0 x6 hc y7e ff3 fs3 fc0 sc0 ls22 ws81">Limiting Rows Using a Selection 2<span class="ls65 ws1">-<span class="ls66">3</span></span></div><div class="t m0 x6 hc y7f ff3 fs3 fc0 sc0 ls99 ws82">Limiting the Rows Selected 2<span class="ls65 ws1">-<span class="ls66">4</span></span></div><div class="t m0 x6 hc y80 ff3 fs3 fc0 sc0 ls9a ws83">Using the WHERE Clause 2<span class="ls65 ws1">-<span class="ls66">5</span></span></div><div class="t m0 x6 hc y81 ff3 fs3 fc0 sc0 ls9b ws3d">Character Strings and Dates 2<span class="ls65 ws1">-<span class="ls66">6</span></span></div><div class="t m0 x6 hc y82 ff3 fs3 fc0 sc0 ls4b ws84">Comparison Conditions 2<span class="_ _3"></span><span class="ls65 ws1">-<span class="ls66">7</span></span></div><div class="t m0 x6 hc y83 ff3 fs3 fc0 sc0 ls6d ws85">Using Comparison Conditions 2<span class="ls65 ws1">-<span class="ls66">8</span></span></div><div class="t m0 x6 hc y84 ff3 fs3 fc0 sc0 ls9c ws86">Other Comparison Conditions 2<span class="ls65 ws1">-<span class="ls66">9</span></span></div><div class="t m0 x6 hc y85 ff3 fs3 fc0 sc0 ls9d ws87">Using the BETWEEN Condition 2<span class="ls65 ws1">-<span class="ls66">10</span></span></div><div class="t m0 x6 hc y86 ff3 fs3 fc0 sc0 ls9e ws88">Using the IN Condition 2<span class="_ _1"></span><span class="ls65 ws1">-<span class="ls66">11</span></span></div><div class="t m0 x6 hc y87 ff3 fs3 fc0 sc0 ls9f ws89">Using the LIKE Condition 2<span class="_ _1"></span><span class="ls65 ws1">-<span class="ls66">12</span></span></div><div class="t m0 x6 hc y88 ff3 fs3 fc0 sc0 ls66 ws8a">Using the NULL Conditions 2<span class="ls65 ws1">-<span class="ls66">14</span></span></div><div class="t m0 x6 hc y89 ff3 fs3 fc0 sc0 ls51 ws8b">Logical Conditions 2<span class="ls65 ws1">-<span class="ls66">15</span></span></div><div class="t m0 x6 hc y8a ff3 fs3 fc0 sc0 lsa0 ws8c">Using the AND Operator 2<span class="ls65 ws1">-<span class="ls66">16</span></span></div><div class="t m0 x6 hc y8b ff3 fs3 fc0 sc0 lsa1 ws8d">Using the OR Operator 2<span class="_ _1"></span><span class="ls65 ws1">-<span class="ls66">17</span></span></div><div class="t m0 x6 hc y8c ff3 fs3 fc0 sc0 lsa2 ws3">Using the NOT Operator 2<span class="ls65 ws1">-<span class="ls66">18</span></span></div><div class="t m0 x6 hc y8d ff3 fs3 fc0 sc0 lsa3 ws8e">Rules of Precedence 2<span class="ls65 ws1">-<span class="ls66">19</span></span></div><div class="t m0 x6 hc y8e ff3 fs3 fc0 sc0 lsa4 ws8f">ORDER BY Clause 2<span class="ls65 ws1">-<span class="ls86">22</span></span></div><div class="t m0 x6 hc y8f ff3 fs3 fc0 sc0 lsa5 ws90">Sorting in Descending Order 2<span class="_ _1"></span><span class="ls65 ws1">-<span class="ls66">23</span></span></div><div class="t m0 x6 hc y90 ff3 fs3 fc0 sc0 ls35 ws91">Sorting by Column Alias 2<span class="_ _1"></span><span class="ls65 ws1">-<span class="ls66">24</span></span></div><div class="t m0 x6 hc y91 ff3 fs3 fc0 sc0 ls45 ws92">Sorting by Multiple Columns 2<span class="ls65 ws1">-<span class="ls66">25</span></span></div><div class="t m0 x6 hc y92 ff3 fs3 fc0 sc0 ls96 ws7f">Summary 2<span class="ls65 ws1">-<span class="ls66">26</span></span></div><div class="t m0 x6 hc y93 ff3 fs3 fc0 sc0 ls87 ws80">Practice 2 Overview 2<span class="ls65 ws1">-<span class="ls86">27</span></span></div><div class="t m0 x9 h3 y60 ff1 fs1 fc0 sc0 lsa6 ws1">v</div></div><div class="pi" data-data='{"ctm":[1.568627,0.000000,0.000000,1.568627,0.000000,0.000000]}'></div></div>
