?? sql語法手冊(cè).htm
字號(hào):
<P class=MsoNormal><SPAN lang=EN-US
style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt">Kari<O:P></O:P></SPAN></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><SPAN lang=EN-US
style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt">Storgt
20<O:P></O:P></SPAN></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><SPAN lang=EN-US
style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt">Stavanger<O:P></O:P></SPAN></P></TD></TR></TBODY></TABLE>
<P class=MsoNormal><SPAN lang=EN-US
style="mso-fareast-font-family: PMingLiU; mso-fareast-language: ZH-TW"><![if !supportEmptyParas]> <![endif]><O:P></O:P></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US
style="mso-fareast-font-family: PMingLiU; mso-fareast-language: ZH-TW"><![if !supportEmptyParas]> <![endif]><O:P></O:P></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US
style="mso-fareast-font-family: PMingLiU; mso-fareast-language: ZH-TW"><![if !supportEmptyParas]> <![endif]><O:P></O:P></SPAN></P>
<H1><SPAN lang=EN-US>Where</SPAN><SPAN lang=EN-US
style="mso-fareast-font-family: PMingLiU; mso-fareast-language: ZH-TW"><O:P></O:P></SPAN></H1>
<P class=MsoNormal><B><SPAN
style="FONT-FAMILY: 宋體; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">用途：</SPAN><SPAN
lang=EN-US><O:P></O:P></SPAN></B></P>
<P class=MsoNormal
style="TEXT-INDENT: 10.5pt; mso-char-indent-count: 1.0; mso-char-indent-size: 10.5pt"><SPAN
style="FONT-FAMILY: 宋體; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">被用來規(guī)定一種選擇查詢的標(biāo)準(zhǔn)</SPAN><SPAN
lang=EN-US
style="mso-fareast-font-family: PMingLiU; mso-fareast-language: ZH-TW"><O:P></O:P></SPAN></P>
<P class=MsoNormal><B><SPAN
style="FONT-FAMILY: 宋體; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">語法：</SPAN><SPAN
lang=EN-US><O:P></O:P></SPAN></B></P>
<TABLE bgColor=#eeeedd border=1 cellPadding=0 cellSpacing=0
style="BACKGROUND: #eeeedd; WIDTH: 100%; mso-cellspacing: 0cm"
width="100%">
<TBODY>
<TR>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt"><PRE><SPAN lang=EN-US style="COLOR: black; FONT-SIZE: 9.5pt">SELECT column FROM table WHERE column condition value<O:P></O:P></SPAN></PRE></TD></TR></TBODY></TABLE>
<P style="MARGIN: 0cm 0cm 0pt"><SPAN
style="COLOR: black; FONT-FAMILY: 宋體; FONT-SIZE: 8.5pt; mso-ascii-font-family: Verdana; mso-hansi-font-family: Verdana">下面的操作符能被使用在</SPAN><SPAN
lang=EN-US style="COLOR: black; FONT-SIZE: 8.5pt">WHERE</SPAN><SPAN
style="COLOR: black; FONT-FAMILY: 宋體; FONT-SIZE: 8.5pt; mso-ascii-font-family: Verdana; mso-hansi-font-family: Verdana">中：</SPAN><SPAN
lang=EN-US
style="COLOR: black; FONT-SIZE: 8.5pt; mso-fareast-font-family: PMingLiU; mso-fareast-language: ZH-TW"><O:P></O:P></SPAN></P>
<P style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US
style="COLOR: black; FONT-SIZE: 8.5pt">=,<>,>,<,>=,<=,BETWEEN,LIKE</SPAN><SPAN
lang=EN-US
style="COLOR: black; FONT-SIZE: 8.5pt; mso-fareast-font-family: PMingLiU; mso-fareast-language: ZH-TW"><O:P></O:P></SPAN></P>
<P style="MARGIN: 0cm 0cm 0pt"><SPAN
style="COLOR: black; FONT-FAMILY: 宋體; FONT-SIZE: 8.5pt; mso-ascii-font-family: Verdana; mso-hansi-font-family: Verdana">注意：</SPAN><SPAN
style="COLOR: black; FONT-SIZE: 8.5pt"> </SPAN><SPAN
style="COLOR: black; FONT-FAMILY: 宋體; FONT-SIZE: 8.5pt; mso-ascii-font-family: Verdana; mso-hansi-font-family: Verdana">在某些</SPAN><SPAN
lang=EN-US style="COLOR: black; FONT-SIZE: 8.5pt">SQL</SPAN><SPAN
style="COLOR: black; FONT-FAMILY: 宋體; FONT-SIZE: 8.5pt; mso-ascii-font-family: Verdana; mso-hansi-font-family: Verdana">的版本中不等號(hào)</SPAN><SPAN
lang=EN-US style="COLOR: black; FONT-SIZE: 8.5pt">< ></SPAN><SPAN
style="COLOR: black; FONT-FAMILY: 宋體; FONT-SIZE: 8.5pt; mso-ascii-font-family: Verdana; mso-hansi-font-family: Verdana">能被寫作為</SPAN><SPAN
lang=EN-US style="COLOR: black; FONT-SIZE: 8.5pt">!=</SPAN><SPAN
lang=EN-US
style="COLOR: black; FONT-SIZE: 8.5pt; mso-fareast-language: ZH-TW"><O:P></O:P></SPAN></P>
<P class=MsoNormal><B><SPAN
style="FONT-FAMILY: 宋體; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">解釋：</SPAN></B><B><SPAN
lang=EN-US style="mso-fareast-language: ZH-TW"><O:P></O:P></SPAN></B></P>
<P class=MsoNormal><SPAN lang=EN-US><SPAN style="mso-spacerun: yes">
</SPAN>SELECT</SPAN><SPAN
style="FONT-FAMILY: 宋體; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">語句返回</SPAN><SPAN
lang=EN-US>WHERE</SPAN><SPAN
style="FONT-FAMILY: 宋體; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">子句中條件為</SPAN><SPAN
lang=EN-US>true</SPAN><SPAN
style="FONT-FAMILY: 宋體; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">的數(shù)據(jù)</SPAN><SPAN
lang=EN-US
style="mso-fareast-font-family: PMingLiU; mso-fareast-language: ZH-TW"><O:P></O:P></SPAN></P>
<P class=MsoNormal><B><SPAN
style="FONT-FAMILY: 宋體; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">例：</SPAN></B><B><SPAN
lang=EN-US style="mso-fareast-language: ZH-TW"><O:P></O:P></SPAN></B></P>
<P><SPAN
style="COLOR: black; FONT-FAMILY: 宋體; FONT-SIZE: 8.5pt; mso-ascii-font-family: Verdana; mso-hansi-font-family: Verdana">從</SPAN><SPAN
lang=EN-US style="COLOR: black; FONT-SIZE: 8.5pt">”<B>
</B>Persons”</SPAN><SPAN
style="COLOR: black; FONT-FAMILY: 宋體; FONT-SIZE: 8.5pt; mso-ascii-font-family: Verdana; mso-hansi-font-family: Verdana">表中選出生活在</SPAN><SPAN
lang=EN-US style="COLOR: black; FONT-SIZE: 8.5pt">” Sandnes” </SPAN><SPAN
style="COLOR: black; FONT-FAMILY: 宋體; FONT-SIZE: 8.5pt; mso-ascii-font-family: Verdana; mso-hansi-font-family: Verdana">的人</SPAN><SPAN
lang=EN-US style="COLOR: black; FONT-SIZE: 8.5pt"><O:P></O:P></SPAN></P>
<TABLE bgColor=#eeeedd border=1 cellPadding=0 cellSpacing=0
style="BACKGROUND: #eeeedd; WIDTH: 100%; mso-cellspacing: 0cm"
width="100%">
<TBODY>
<TR>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt"><PRE><SPAN lang=EN-US style="COLOR: black; FONT-SIZE: 9.5pt">SELECT * FROM Persons WHERE City='Sandnes'<O:P></O:P></SPAN></PRE></TD></TR></TBODY></TABLE>
<P><SPAN lang=EN-US style="COLOR: black; FONT-SIZE: 8.5pt"><SPAN
style="mso-spacerun: yes"> </SPAN>"Persons" </SPAN><SPAN
style="COLOR: black; FONT-FAMILY: 宋體; FONT-SIZE: 8.5pt; mso-ascii-font-family: Verdana; mso-hansi-font-family: Verdana">表中的數(shù)據(jù)有</SPAN><B><SPAN
lang=EN-US style="COLOR: black; FONT-SIZE: 8.5pt">:</SPAN></B><SPAN
lang=EN-US style="COLOR: black; FONT-SIZE: 8.5pt"><O:P></O:P></SPAN></P>
<TABLE bgColor=#eeeedd border=1 cellPadding=0 cellSpacing=0
style="BACKGROUND: #eeeedd; WIDTH: 100%; mso-cellspacing: 0cm"
width="100%">
<TBODY>
<TR>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><B><SPAN lang=EN-US
style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt">LastName</SPAN></B><B><SPAN
lang=EN-US
style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt; mso-fareast-font-family: 'Arial Unicode MS'; mso-bidi-font-family: 'Arial Unicode MS'"><O:P></O:P></SPAN></B></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><B><SPAN lang=EN-US
style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt">FirstName</SPAN></B><B><SPAN
lang=EN-US
style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt; mso-fareast-font-family: 'Arial Unicode MS'; mso-bidi-font-family: 'Arial Unicode MS'"><O:P></O:P></SPAN></B></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><B><SPAN lang=EN-US
style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt">Address</SPAN></B><B><SPAN
lang=EN-US
style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt; mso-fareast-font-family: 'Arial Unicode MS'; mso-bidi-font-family: 'Arial Unicode MS'"><O:P></O:P></SPAN></B></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><B><SPAN lang=EN-US
style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt">City</SPAN></B><B><SPAN
lang=EN-US
style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt; mso-fareast-font-family: 'Arial Unicode MS'; mso-bidi-font-family: 'Arial Unicode MS'"><O:P></O:P></SPAN></B></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><B><SPAN lang=EN-US
style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt">Year</SPAN></B><B><SPAN
lang=EN-US
style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt; mso-fareast-font-family: 'Arial Unicode MS'; mso-bidi-font-family: 'Arial Unicode MS'"><O:P></O:P></SPAN></B></P></TD></TR>
<TR>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><SPAN lang=EN-US
style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt">Hansen</SPAN><SPAN
lang=EN-US
style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt; mso-fareast-font-family: 'Arial Unicode MS'; mso-bidi-font-family: 'Arial Unicode MS'"><O:P></O:P></SPAN></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><SPAN lang=EN-US
style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt">Ola</SPAN><SPAN
lang=EN-US
style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt; mso-fareast-font-family: 'Arial Unicode MS'; mso-bidi-font-family: 'Arial Unicode MS'"><O:P></O:P></SPAN></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><SPAN lang=EN-US
style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt">Timoteivn
10</SPAN><SPAN lang=EN-US
style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt; mso-fareast-font-family: 'Arial Unicode MS'; mso-bidi-font-family: 'Arial Unicode MS'"><O:P></O:P></SPAN></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><SPAN lang=EN-US
style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt">Sandnes</SPAN><SPAN
lang=EN-US
style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt; mso-fareast-font-family: 'Arial Unicode MS'; mso-bidi-font-family: 'Arial Unicode MS'"><O:P></O:P></SPAN></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><SPAN lang=EN-US
style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt">1951</SPAN><SPAN
lang=EN-US
style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt; mso-fareast-font-family: 'Arial Unicode MS'; mso-bidi-font-family: 'Arial Unicode MS'"><O:P></O:P></SPAN></P></TD></TR>
<TR>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><SPAN lang=EN-US
style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt">Svendson</SPAN><SPAN
lang=EN-US
style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt; mso-fareast-font-family: 'Arial Unicode MS'; mso-bidi-font-family: 'Arial Unicode MS'"><O:P></O:P></SPAN></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><SPAN lang=EN-US
style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt">Tove</SPAN><SPAN
lang=EN-US
style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt; mso-fareast-font-family: 'Arial Unicode MS'; mso-bidi-font-family: 'Arial Unicode MS'"><O:P></O:P></SPAN></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><SPAN lang=EN-US
style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt">Borgvn
23</SPAN><SPAN lang=EN-US
style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt; mso-fareast-font-family: 'Arial Unicode MS'; mso-bidi-font-family: 'Arial Unicode MS'"><O:P></O:P></SPAN></P></TD>
<TD
style="PADDING-BOTTOM: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-RIGHT: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><SPAN lang=EN-US
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -