sqlserver sql语句学习..有注释_sql_sqlserver_其他

<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://static.pudn.com/base/css/base.min.css"> <link rel="stylesheet" href="https://static.pudn.com/base/css/fancy.min.css"> <link rel="stylesheet" href="https://static.pudn.com/prod/directory_preview_static/627ed9719b6e2b6d5554e616/raw.css"> <script src="https://static.pudn.com/base/js/compatibility.min.js"></script> <script src="https://static.pudn.com/base/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://static.pudn.com/prod/directory_preview_static/627ed9719b6e2b6d5554e616/bg1.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x1 h3 y2 ff1 fs0 fc0 sc0 ls0 ws0">SQL TOP <span class="ff2 sc1">子句</span></div><div class="t m0 x2 h4 y3 ff3 fs1 fc0 sc0 ls0 ws0"><span class="_ _0"> </span><span class="ff4 fs2 fc1">Previous Page<span class="_ _1"></span> <span class="_ _2"> </span> <span class="fc0"> </span></span></div><div class="t m0 x2 h4 y4 ff3 fs1 fc0 sc0 ls0 ws0"><span class="_ _0"> </span><span class="ff4 fs2 fc1">Next Page<span class="_ _3"></span> <span class="_ _4"> </span> <span class="fc0"> </span></span></div><div class="t m0 x3 h5 y5 ff1 fs3 fc0 sc0 ls0 ws0">TOP <span class="ff2 sc1">子句</span></div><div class="t m0 x3 h6 y6 ff4 fs2 fc0 sc0 ls0 ws0">TOP <span class="ff2">子句用于规定要返回的记录的数目。</span></div><div class="t m0 x3 h6 y7 ff2 fs2 fc0 sc0 ls0 ws0">对于拥有数千条记录的大型表来说，<span class="ff4">TOP </span>子句是非常有用的。</div><div class="t m0 x3 h6 y8 ff2 fs2 fc0 sc1 ls0 ws0">注释：<span class="sc0">并非所有的数据库系统都支持 <span class="ff4">TOP </span>子句。</span></div><div class="t m0 x3 h6 y9 ff1 fs2 fc0 sc0 ls0 ws0">SQL Server <span class="ff2 sc1">的语法：</span></div><div class="t m0 x3 h7 ya ff5 fs2 fc0 sc0 ls0 ws0">SELECT TOP number|percent column_name(s)</div><div class="t m0 x3 h7 yb ff5 fs2 fc0 sc0 ls0 ws0">FROM table_name</div><div class="t m0 x3 h5 yc ff1 fs3 fc0 sc0 ls0 ws0">MySQL <span class="ff2 sc1">和 </span>Oracle <span class="ff2 sc1">中的 </span>SQL SELECT TOP <span class="ff2 sc1">是等价的</span></div><div class="t m0 x3 h6 yd ff1 fs2 fc0 sc0 ls0 ws0">MySQL <span class="ff2 sc1">语法</span></div><div class="t m0 x3 h7 ye ff5 fs2 fc0 sc0 ls0 ws0">SELECT column_name(s)</div><div class="t m0 x3 h7 yf ff5 fs2 fc0 sc0 ls0 ws0">FROM table_name</div><div class="t m0 x3 h7 y10 ff5 fs2 fc0 sc0 ls0 ws0">LIMIT number</div><div class="t m0 x3 h6 y11 ff2 fs2 fc0 sc1 ls0 ws0">例子</div><div class="t m0 x3 h7 y12 ff5 fs2 fc0 sc0 ls0 ws0">SELECT *</div><div class="t m0 x3 h7 y13 ff5 fs2 fc0 sc0 ls0 ws0">FROM Persons</div><div class="t m0 x3 h7 y14 ff5 fs2 fc0 sc0 ls0 ws0">LIMIT 5</div><div class="t m0 x3 h6 y15 ff1 fs2 fc0 sc0 ls0 ws0">Oracle <span class="ff2 sc1">语法</span></div><div class="t m0 x3 h7 y16 ff5 fs2 fc0 sc0 ls0 ws0">SELECT column_name(s)</div><div class="t m0 x3 h7 y17 ff5 fs2 fc0 sc0 ls0 ws0">FROM table_name</div><div class="t m0 x3 h7 y18 ff5 fs2 fc0 sc0 ls0 ws0">WHERE ROWNUM <= number</div><div class="t m0 x3 h6 y19 ff2 fs2 fc0 sc1 ls0 ws0">例子</div><div class="t m0 x3 h7 y1a ff5 fs2 fc0 sc0 ls0 ws0">SELECT *</div><div class="t m0 x3 h7 y1b ff5 fs2 fc0 sc0 ls0 ws0">FROM Persons</div><div class="t m0 x3 h7 y1c ff5 fs2 fc0 sc0 ls0 ws0">WHERE ROWNUM <= 5</div><div class="t m0 x3 h5 y1d ff2 fs3 fc0 sc1 ls0 ws0">原始的表 <span class="ff1 sc0">(</span>用在例子中的<span class="ff1 sc0">)</span>：</div><div class="t m0 x3 h8 y1e ff6 fs4 fc0 sc0 ls0 ws0">Persons <span class="ff2">表</span>:</div></div><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a></div><div class="pi" data-data='{"ctm":[1.611850,0.000000,0.000000,1.611850,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://static.pudn.com/prod/directory_preview_static/627ed9719b6e2b6d5554e616/bg2.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x3 h7 y1f ff7 fs2 fc0 sc0 ls0 ws0">Id<span class="_ _5"> </span>LastName<span class="_ _6"> </span>FirstName<span class="_ _7"> </span>Address<span class="_ _8"> </span>City</div><div class="t m0 x4 h7 y20 ff8 fs2 fc0 sc0 ls0 ws0">1<span class="_ _9"> </span>Adams<span class="_ _a"> </span>John<span class="_ _b"> </span>Oxford Street<span class="_ _c"> </span>London</div><div class="t m0 x4 h7 y21 ff8 fs2 fc0 sc0 ls0 ws0">2<span class="_ _d"> </span>Bush<span class="_ _e"> </span>George<span class="_ _f"> </span>Fifth Avenue<span class="_ _10"> </span>New York</div><div class="t m0 x4 h7 y22 ff8 fs2 fc0 sc0 ls0 ws0">3<span class="_ _11"> </span>Carter<span class="_ _12"> </span>Thomas<span class="_ _13"> </span>Changan Street<span class="_ _10"> </span>B<span class="_ _14"></span>eijing</div><div class="t m0 x4 h7 y23 ff8 fs2 fc0 sc0 ls0 ws0">4<span class="_ _15"> </span>Obama<span class="_ _12"> </span>Barack<span class="_ _16"> </span>Pennsylvania Avenue<span class="_ _17"> </span>Washington</div><div class="t m0 x3 h5 y24 ff1 fs3 fc0 sc0 ls0 ws0">SQL TOP <span class="ff2 sc1">实例</span></div><div class="t m0 x3 h6 y25 ff2 fs2 fc0 sc0 ls0 ws0">现在，我们希望从上面的 <span class="ff4">"Persons" </span>表中选取头两条记录。</div><div class="t m0 x3 h6 y26 ff2 fs2 fc0 sc0 ls0 ws0">我们可以使用下面的 <span class="ff4">SELECT </span>语句：</div><div class="t m0 x3 h9 y27 ff5 fs2 fc0 sc0 ls0 ws0">SELECT <span class="fs5 fc2">TOP 2</span> * FROM Persons</div><div class="t m0 x3 h8 y28 ff2 fs4 fc0 sc0 ls0 ws0">结果：</div><div class="t m0 x3 h7 y29 ff7 fs2 fc0 sc0 ls0 ws0">Id<span class="_ _18"> </span>LastName<span class="_ _19"> </span>FirstName<span class="_ _1a"> </span>Address<span class="_ _1b"> </span>City</div><div class="t m0 x5 h7 y2a ff8 fs2 fc0 sc0 ls0 ws0">1<span class="_ _1c"> </span>Adams<span class="_ _1d"> </span>John<span class="_ _1e"> </span>Oxford Street<span class="_ _1f"> </span>London</div><div class="t m0 x5 h7 y2b ff8 fs2 fc0 sc0 ls0 ws0">2<span class="_ _20"> </span>Bush<span class="_ _21"> </span>George<span class="_ _22"> </span>Fifth Avenue<span class="_ _17"> </span>New York</div><div class="t m0 x3 h5 y2c ff1 fs3 fc0 sc0 ls0 ws0">SQL TOP PERCENT <span class="ff2 sc1">实例</span></div><div class="t m0 x3 h6 y11 ff2 fs2 fc0 sc0 ls0 ws0">现在，我们希望从上面的 <span class="ff4">"Persons" </span>表中选取 <span class="ff4">50% </span>的记录。</div><div class="t m0 x3 h6 y2d ff2 fs2 fc0 sc0 ls0 ws0">我们可以使用下面的 <span class="ff4">SELECT </span>语句：</div><div class="t m0 x3 h9 y2e ff5 fs2 fc0 sc0 ls0 ws0">SELECT <span class="fs5 fc2">TOP 50 PERCENT</span> * FROM Persons</div><div class="t m0 x3 h8 y2f ff2 fs4 fc0 sc0 ls0 ws0">结果：</div><div class="t m0 x3 h7 y30 ff7 fs2 fc0 sc0 ls0 ws0">Id<span class="_ _18"> </span>LastName<span class="_ _19"> </span>FirstName<span class="_ _1a"> </span>Address<span class="_ _1b"> </span>City</div><div class="t m0 x5 h7 y31 ff8 fs2 fc0 sc0 ls0 ws0">1<span class="_ _1c"> </span>Adams<span class="_ _1d"> </span>John<span class="_ _1e"> </span>Oxford Street<span class="_ _1f"> </span>London</div><div class="t m0 x5 h7 y32 ff8 fs2 fc0 sc0 ls0 ws0">2<span class="_ _20"> </span>Bush<span class="_ _21"> </span>George<span class="_ _22"> </span>Fifth Avenue<span class="_ _17"> </span>New York</div><div class="t m0 x1 h3 y33 ff1 fs0 fc0 sc0 ls0 ws0">SQL LIKE <span class="ff2 sc1">操作符</span></div><div class="t m0 x2 h4 y34 ff3 fs1 fc0 sc0 ls0 ws0"><span class="_ _0"> </span><span class="ff4 fs2 fc1">Previous Page<span class="_ _1"></span> <span class="_ _2"> </span> <span class="fc0"> </span></span></div><div class="t m0 x2 h4 y35 ff3 fs1 fc0 sc0 ls0 ws0"><span class="_ _0"> </span><span class="ff4 fs2 fc1">Next Page<span class="_ _3"></span> <span class="_ _4"> </span> <span class="fc0"> </span></span></div><div class="t m0 x3 h6 y36 ff1 fs2 fc0 sc0 ls0 ws0">LIKE <span class="ff2 sc1">操作符用于在 </span>WHERE <span class="ff2 sc1">子句中搜索列中的指定模式。</span></div><div class="t m0 x3 h5 y37 ff1 fs3 fc0 sc0 ls0 ws0">LIKE <span class="ff2 sc1">操作符</span></div><div class="t m0 x3 h6 y38 ff4 fs2 fc0 sc0 ls0 ws0">LIKE <span class="ff2">操作符用于在 </span>WHERE <span class="ff2">子句中搜索列中的指定模式。</span></div></div><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a></div><div class="pi" data-data='{"ctm":[1.611850,0.000000,0.000000,1.611850,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://static.pudn.com/prod/directory_preview_static/627ed9719b6e2b6d5554e616/bg3.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x3 h6 y39 ff1 fs2 fc0 sc0 ls0 ws0">SQL LIKE <span class="ff2 sc1">操作符语法</span></div><div class="t m0 x3 h7 y3a ff5 fs2 fc0 sc0 ls0 ws0">SELECT column_name(s)</div><div class="t m0 x3 h7 y3b ff5 fs2 fc0 sc0 ls0 ws0">FROM table_name</div><div class="t m0 x3 h7 y3c ff5 fs2 fc0 sc0 ls0 ws0">WHERE column_name LIKE pattern</div><div class="t m0 x3 h5 y3d ff2 fs3 fc0 sc1 ls0 ws0">原始的表 <span class="ff1 sc0">(</span>用在例子中的<span class="ff1 sc0">)</span>：</div><div class="t m0 x3 h8 y3e ff6 fs4 fc0 sc0 ls0 ws0">Persons <span class="ff2">表</span>:</div><div class="t m0 x3 h7 y3f ff7 fs2 fc0 sc0 ls0 ws0">Id<span class="_ _23"> </span>LastName<span class="_ _24"> </span>FirstName<span class="_ _25"> </span>Address<span class="_ _26"> </span>City</div><div class="t m0 x6 h7 y40 ff8 fs2 fc0 sc0 ls0 ws0">1<span class="_ _7"> </span>Adams<span class="_ _22"> </span>John<span class="_ _27"> </span>Oxford Street<span class="_ _28"> </span>London</div><div class="t m0 x6 h7 y41 ff8 fs2 fc0 sc0 ls0 ws0">2<span class="_ _29"> </span>Bush<span class="_ _2a"> </span>George<span class="_ _13"> </span>Fifth Avenue<span class="_ _16"> </span>New York</div><div class="t m0 x6 h7 y42 ff8 fs2 fc0 sc0 ls0 ws0">3<span class="_ _2b"> </span>Carter<span class="_ _2c"> </span>Thomas<span class="_ _2d"> </span>Changan Street<span class="_ _2e"> </span>Beijing</div><div class="t m0 x3 h5 y43 ff1 fs3 fc0 sc0 ls0 ws0">LIKE <span class="ff2 sc1">操作符实例</span></div><div class="t m0 x3 h6 y44 ff2 fs2 fc0 sc1 ls0 ws0">例子 <span class="ff1 sc0">1</span></div><div class="t m0 x3 h6 y45 ff2 fs2 fc0 sc0 ls0 ws0">现在，我们希望从上面的 <span class="ff4">"Persons" </span>表中选取居住在以 <span class="ff4">"N" </span>开始的城市里的人：</div><div class="t m0 x3 h6 y46 ff2 fs2 fc0 sc0 ls0 ws0">我们可以使用下面的 <span class="ff4">SELECT </span>语句：</div><div class="t m0 x3 h7 y47 ff5 fs2 fc0 sc0 ls0 ws0">SELECT * FROM Persons</div><div class="t m0 x3 h7 y48 ff5 fs2 fc0 sc0 ls0 ws0">WHERE City LIKE 'N%'</div><div class="t m0 x3 h6 y49 ff2 fs2 fc3 sc2 ls0 ws0">提示：<span class="ff4 fc0 sc0">"%" <span class="ff2">可用于定义通配符（模式中缺少的字母）。</span></span></div><div class="t m0 x3 h8 y4a ff2 fs4 fc0 sc0 ls0 ws0">结果集：</div><div class="t m0 x3 h7 y4b ff7 fs2 fc0 sc0 ls0 ws0">Id<span class="_ _2f"> </span>LastName<span class="_ _1a"> </span>FirstName<span class="_ _30"> </span>Address<span class="_ _31"> </span>City</div><div class="t m0 x5 h7 y4c ff8 fs2 fc0 sc0 ls0 ws0">2<span class="_ _32"> </span>Bush<span class="_ _1d"> </span>George<span class="_ _2a"> </span>Fifth Avenue<span class="_ _33"> </span>New York</div><div class="t m0 x3 h6 y4d ff2 fs2 fc0 sc1 ls0 ws0">例子 <span class="ff1 sc0">2</span></div><div class="t m0 x3 h6 y4e ff2 fs2 fc0 sc0 ls0 ws0">接下来，我们希望从 <span class="ff4">"Persons" </span>表中选取居住在以 <span class="ff4">"g" </span>结尾的城市里的人：</div><div class="t m0 x3 h6 y4f ff2 fs2 fc0 sc0 ls0 ws0">我们可以使用下面的 <span class="ff4">SELECT </span>语句：</div><div class="t m0 x3 h7 y50 ff5 fs2 fc0 sc0 ls0 ws0">SELECT * FROM Persons</div><div class="t m0 x3 h7 y51 ff5 fs2 fc0 sc0 ls0 ws0">WHERE City LIKE '%g'</div><div class="t m0 x3 h8 y52 ff2 fs4 fc0 sc0 ls0 ws0">结果集：</div><div class="t m0 x3 h7 y53 ff7 fs2 fc0 sc0 ls0 ws0">Id<span class="_ _2f"> </span>LastName<span class="_ _1a"> </span>FirstName<span class="_ _34"> </span>Address<span class="_ _35"> </span>City</div></div></div><div class="pi" data-data='{"ctm":[1.611850,0.000000,0.000000,1.611850,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://static.pudn.com/prod/directory_preview_static/627ed9719b6e2b6d5554e616/bg4.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x5 h7 y1f ff8 fs2 fc0 sc0 ls0 ws0">3<span class="_ _36"> </span>Carter<span class="_ _37"> </span>Thomas<span class="_ _38"> </span>Changan Street<span class="_ _33"> </span>Beijing</div><div class="t m0 x3 h6 y54 ff2 fs2 fc0 sc1 ls0 ws0">例子 <span class="ff1 sc0">3</span></div><div class="t m0 x3 h6 y55 ff2 fs2 fc0 sc0 ls0 ws0">接下来，我们希望从 <span class="ff4">"Persons" </span>表中选取居住在包含 <span class="ff4">"lon" </span>的城市里的人：</div><div class="t m0 x3 h6 y56 ff2 fs2 fc0 sc0 ls0 ws0">我们可以使用下面的 <span class="ff4">SELECT </span>语句：</div><div class="t m0 x3 h7 y57 ff5 fs2 fc0 sc0 ls0 ws0">SELECT * FROM Persons</div><div class="t m0 x3 h7 y58 ff5 fs2 fc0 sc0 ls0 ws0">WHERE City LIKE '%lon%'</div><div class="t m0 x3 h8 y59 ff2 fs4 fc0 sc0 ls0 ws0">结果集：</div><div class="t m0 x3 h7 y5a ff7 fs2 fc0 sc0 ls0 ws0">Id<span class="_ _39"> </span>LastName<span class="_ _3a"> </span>FirstName<span class="_ _3b"> </span>Address<span class="_ _3c"> </span>City</div><div class="t m0 x7 h7 y5b ff8 fs2 fc0 sc0 ls0 ws0">1<span class="_ _3d"> </span>Adams<span class="_ _27"> </span>John<span class="_ _27"> </span>Oxford Street<span class="_ _30"> </span>London</div><div class="t m0 x3 h6 y5c ff2 fs2 fc0 sc1 ls0 ws0">例子 <span class="ff1 sc0">4</span></div><div class="t m0 x3 h6 y5d ff2 fs2 fc0 sc0 ls0 ws0">通过使用 <span class="ff4">NOT </span>关键字，我们可以从 <span class="ff4">"Persons" </span>表中选取居住在<span class="sc1">不包含</span> <span class="ff4">"lon" </span>的城市里的人：</div><div class="t m0 x3 h6 y5e ff2 fs2 fc0 sc0 ls0 ws0">我们可以使用下面的 <span class="ff4">SELECT </span>语句：</div><div class="t m0 x3 h7 y5f ff5 fs2 fc0 sc0 ls0 ws0">SELECT * FROM Persons</div><div class="t m0 x3 h7 y60 ff5 fs2 fc0 sc0 ls0 ws0">WHERE City NOT LIKE '%lon%'</div><div class="t m0 x3 h8 y61 ff2 fs4 fc0 sc0 ls0 ws0">结果集：</div><div class="t m0 x3 h7 y62 ff7 fs2 fc0 sc0 ls0 ws0">Id<span class="_ _23"> </span>LastName<span class="_ _24"> </span>FirstName<span class="_ _25"> </span>Address<span class="_ _26"> </span>City</div><div class="t m0 x6 h7 y63 ff8 fs2 fc0 sc0 ls0 ws0">2<span class="_ _29"> </span>Bush<span class="_ _2a"> </span>George<span class="_ _13"> </span>Fifth Avenue<span class="_ _16"> </span>New York</div><div class="t m0 x6 h7 y64 ff8 fs2 fc0 sc0 ls0 ws0">3<span class="_ _2b"> </span>Carter<span class="_ _2c"> </span>Thomas<span class="_ _2d"> </span>Changan Street<span class="_ _2e"> </span>Beijing</div><div class="t m0 x1 h3 y65 ff1 fs0 fc0 sc0 ls0 ws0">SQL <span class="ff2 sc1">通配符</span></div><div class="t m0 x2 h4 y66 ff3 fs1 fc0 sc0 ls0 ws0"><span class="_ _0"> </span><span class="ff4 fs2 fc1">Previous Page<span class="_ _1"></span> <span class="_ _2"> </span> <span class="fc0"> </span></span></div><div class="t m0 x2 h4 y67 ff3 fs1 fc0 sc0 ls0 ws0"><span class="_ _0"> </span><span class="ff4 fs2 fc1">Next Page<span class="_ _3"></span> <span class="_ _4"> </span> <span class="fc0"> </span></span></div><div class="t m0 x3 h6 y68 ff2 fs2 fc0 sc1 ls0 ws0">在搜索数据库中的数据时，您可以使用 <span class="ff1 sc0">SQL </span>通配符。</div><div class="t m0 x3 h5 y69 ff1 fs3 fc0 sc0 ls0 ws0">SQL <span class="ff2 sc1">通配符</span></div><div class="t m0 x3 h6 y6a ff2 fs2 fc0 sc0 ls0 ws0">在搜索数据库中的数据时，<span class="ff4">SQL </span>通配符可以替代一个或多个字符。</div><div class="t m0 x3 h6 y6b ff4 fs2 fc0 sc0 ls0 ws0">SQL <span class="ff2">通配符必须与 </span>LIKE <span class="ff2">运算符一起使用。</span></div><div class="t m0 x3 h8 y6c ff2 fs2 fc0 sc0 ls0 ws0">在 <span class="ff4">SQ<span class="ff6 fs4">L<span class="_ _14"></span> <span class="ff2">中，可使用以下通配符：</span></span></span></div><div class="t m0 x3 h6 y6d ff2 fs2 fc0 sc1 ls0 ws0">通配符<span class="_ _3e"> </span>描述</div></div><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a><a class="l" rel='nofollow' onclick='return false;'><div class="d m1"></div></a></div><div class="pi" data-data='{"ctm":[1.611850,0.000000,0.000000,1.611850,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://static.pudn.com/prod/directory_preview_static/627ed9719b6e2b6d5554e616/bg5.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x8 h7 y1f ff8 fs2 fc0 sc0 ls0 ws0">%</div><div class="t m0 x9 h6 y6e ff2 fs2 fc0 sc0 ls0 ws0">替代一个或多个字符</div><div class="t m0 xa h7 y20 ff8 fs2 fc0 sc0 ls0 ws0">_</div><div class="t m0 xb h6 y6f ff2 fs2 fc0 sc0 ls0 ws0">仅替代一个字符</div><div class="t m0 xc h7 y21 ff8 fs2 fc0 sc0 ls0 ws0">[charlist]</div><div class="t m0 xd h6 y70 ff2 fs2 fc0 sc0 ls0 ws0">字符列中的任何单一字符</div><div class="t m0 xe h7 y71 ff8 fs2 fc0 sc0 ls0 ws0">[^charlist]</div><div class="t m0 xf h6 y72 ff2 fs2 fc0 sc0 ls0 ws0">或者</div><div class="t m0 x10 h7 y73 ff8 fs2 fc0 sc0 ls0 ws0">[!charlist]</div><div class="t m0 x11 h6 y74 ff2 fs2 fc0 sc0 ls0 ws0">不在字符列中的任何单一字符</div><div class="t m0 x3 h5 y75 ff2 fs3 fc0 sc1 ls0 ws0">原始的表 <span class="ff1 sc0">(</span>用在例子中的<span class="ff1 sc0">)</span>：</div><div class="t m0 x3 h8 y76 ff6 fs4 fc0 sc0 ls0 ws0">Persons <span class="ff2">表</span>:</div><div class="t m0 x3 h7 y77 ff7 fs2 fc0 sc0 ls0 ws0">Id<span class="_ _23"> </span>LastName<span class="_ _24"> </span>FirstName<span class="_ _25"> </span>Address<span class="_ _26"> </span>City</div><div class="t m0 x6 h7 y78 ff8 fs2 fc0 sc0 ls0 ws0">1<span class="_ _7"> </span>Adams<span class="_ _22"> </span>John<span class="_ _27"> </span>Oxford Street<span class="_ _28"> </span>London</div><div class="t m0 x6 h7 y79 ff8 fs2 fc0 sc0 ls0 ws0">2<span class="_ _29"> </span>Bush<span class="_ _2a"> </span>George<span class="_ _13"> </span>Fifth Avenue<span class="_ _16"> </span>New York</div><div class="t m0 x6 h7 y7a ff8 fs2 fc0 sc0 ls0 ws0">3<span class="_ _2b"> </span>Carter<span class="_ _2c"> </span>Thomas<span class="_ _2d"> </span>Changan Street<span class="_ _2e"> </span>Beijing</div><div class="t m0 x3 h5 y7b ff2 fs3 fc0 sc1 ls0 ws0">使用 <span class="ff1 sc0">% </span>通配符</div><div class="t m0 x3 h6 y7c ff2 fs2 fc0 sc1 ls0 ws0">例子 <span class="ff1 sc0">1</span></div><div class="t m0 x3 h6 y7d ff2 fs2 fc0 sc0 ls0 ws0">现在，我们希望从上面的 <span class="ff4">"Persons" </span>表中选取居住在以 <span class="ff4">"Ne" </span>开始的城市里的人：</div><div class="t m0 x3 h6 y7e ff2 fs2 fc0 sc0 ls0 ws0">我们可以使用下面的 <span class="ff4">SELECT </span>语句：</div><div class="t m0 x3 h7 y7f ff5 fs2 fc0 sc0 ls0 ws0">SELECT * FROM Persons</div><div class="t m0 x3 h7 y80 ff5 fs2 fc0 sc0 ls0 ws0">WHERE City LIKE 'Ne%'</div><div class="t m0 x3 h8 y81 ff2 fs4 fc0 sc0 ls0 ws0">结果集：</div><div class="t m0 x3 h7 y82 ff7 fs2 fc0 sc0 ls0 ws0">Id<span class="_ _2f"> </span>LastName<span class="_ _1a"> </span>FirstName<span class="_ _30"> </span>Address<span class="_ _31"> </span>City</div><div class="t m0 x5 h7 y83 ff8 fs2 fc0 sc0 ls0 ws0">2<span class="_ _32"> </span>Bush<span class="_ _1d"> </span>George<span class="_ _2a"> </span>Fifth Avenue<span class="_ _33"> </span>New York</div><div class="t m0 x3 h6 y84 ff2 fs2 fc0 sc1 ls0 ws0">例子 <span class="ff1 sc0">2</span></div><div class="t m0 x3 h6 y85 ff2 fs2 fc0 sc0 ls0 ws0">接下来，我们希望从 <span class="ff4">"Persons" </span>表中选取居住在包含 <span class="ff4">"lond" </span>的城市里的人：</div><div class="t m0 x3 h6 y86 ff2 fs2 fc0 sc0 ls0 ws0">我们可以使用下面的 <span class="ff4">SELECT </span>语句：</div><div class="t m0 x3 h7 y87 ff5 fs2 fc0 sc0 ls0 ws0">SELECT * FROM Persons</div><div class="t m0 x3 h7 y88 ff5 fs2 fc0 sc0 ls0 ws0">WHERE City LIKE '%lond%'</div><div class="t m0 x3 h8 y89 ff2 fs4 fc0 sc0 ls0 ws0">结果集：</div></div></div><div class="pi" data-data='{"ctm":[1.611850,0.000000,0.000000,1.611850,0.000000,0.000000]}'></div></div>