?? sql語(yǔ)法手冊(cè).htm
字號(hào):
style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana; mso-fareast-font-family: 'Arial Unicode MS'; mso-bidi-font-family: 'Arial Unicode MS'"><O:P></O:P></SPAN></P></TD>
<TD
style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><SPAN lang=EN-US
style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana">Ola</SPAN><SPAN
lang=EN-US
style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana; mso-fareast-font-family: 'Arial Unicode MS'; mso-bidi-font-family: 'Arial Unicode MS'"><O:P></O:P></SPAN></P></TD>
<TD
style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><SPAN lang=EN-US
style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana">Timoteivn
10</SPAN><SPAN lang=EN-US
style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana; mso-fareast-font-family: 'Arial Unicode MS'; mso-bidi-font-family: 'Arial Unicode MS'"><O:P></O:P></SPAN></P></TD>
<TD
style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><SPAN lang=EN-US
style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana">Sandnes</SPAN><SPAN
lang=EN-US
style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana; mso-fareast-font-family: 'Arial Unicode MS'; mso-bidi-font-family: 'Arial Unicode MS'"><O:P></O:P></SPAN></P></TD>
<TD
style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><SPAN lang=EN-US
style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana">1951</SPAN><SPAN
lang=EN-US
style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana; 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-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><SPAN lang=EN-US
style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana">Svendson</SPAN><SPAN
lang=EN-US
style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana; mso-fareast-font-family: 'Arial Unicode MS'; mso-bidi-font-family: 'Arial Unicode MS'"><O:P></O:P></SPAN></P></TD>
<TD
style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><SPAN lang=EN-US
style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana">Tove</SPAN><SPAN
lang=EN-US
style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana; mso-fareast-font-family: 'Arial Unicode MS'; mso-bidi-font-family: 'Arial Unicode MS'"><O:P></O:P></SPAN></P></TD>
<TD
style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><SPAN lang=EN-US
style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana">Borgvn
23</SPAN><SPAN lang=EN-US
style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana; mso-fareast-font-family: 'Arial Unicode MS'; mso-bidi-font-family: 'Arial Unicode MS'"><O:P></O:P></SPAN></P></TD>
<TD
style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><SPAN lang=EN-US
style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana">Sandnes</SPAN><SPAN
lang=EN-US
style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana; mso-fareast-font-family: 'Arial Unicode MS'; mso-bidi-font-family: 'Arial Unicode MS'"><O:P></O:P></SPAN></P></TD>
<TD
style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><SPAN lang=EN-US
style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana">1978</SPAN><SPAN
lang=EN-US
style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana; 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-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><SPAN lang=EN-US
style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana">Svendson</SPAN><SPAN
lang=EN-US
style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana; mso-fareast-font-family: 'Arial Unicode MS'; mso-bidi-font-family: 'Arial Unicode MS'"><O:P></O:P></SPAN></P></TD>
<TD
style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><SPAN lang=EN-US
style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana">Stale</SPAN><SPAN
lang=EN-US
style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana; mso-fareast-font-family: 'Arial Unicode MS'; mso-bidi-font-family: 'Arial Unicode MS'"><O:P></O:P></SPAN></P></TD>
<TD
style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><SPAN lang=EN-US
style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana">Kaivn
18</SPAN><SPAN lang=EN-US
style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana; mso-fareast-font-family: 'Arial Unicode MS'; mso-bidi-font-family: 'Arial Unicode MS'"><O:P></O:P></SPAN></P></TD>
<TD
style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><SPAN lang=EN-US
style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana">Sandnes</SPAN><SPAN
lang=EN-US
style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana; mso-fareast-font-family: 'Arial Unicode MS'; mso-bidi-font-family: 'Arial Unicode MS'"><O:P></O:P></SPAN></P></TD>
<TD
style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><SPAN lang=EN-US
style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana">1980</SPAN><SPAN
lang=EN-US
style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana; mso-fareast-font-family: 'Arial Unicode MS'; mso-bidi-font-family: 'Arial Unicode MS'"><O:P></O:P></SPAN></P></TD></TR></TBODY></TABLE>
<P class=MsoNormal><SPAN lang=EN-US> <O:P></O:P></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US> <O:P></O:P></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US> <O:P></O:P></SPAN></P>
<H1><SPAN lang=EN-US style="FONT-SIZE: 10pt">And & Or</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-hansi-font-family: 'Times New Roman'; mso-ascii-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-hansi-font-family: 'Times New Roman'; mso-ascii-font-family: 'Times New Roman'">在</SPAN><SPAN
lang=EN-US>WHERE</SPAN><SPAN
style="FONT-FAMILY: 宋體; mso-hansi-font-family: 'Times New Roman'; mso-ascii-font-family: 'Times New Roman'">子句中</SPAN><SPAN
lang=EN-US>AND</SPAN><SPAN
style="FONT-FAMILY: 宋體; mso-hansi-font-family: 'Times New Roman'; mso-ascii-font-family: 'Times New Roman'">和</SPAN><SPAN
lang=EN-US>OR</SPAN><SPAN
style="FONT-FAMILY: 宋體; mso-hansi-font-family: 'Times New Roman'; mso-ascii-font-family: 'Times New Roman'">被用來(lái)連接兩個(gè)或者更多的條件</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-hansi-font-family: 'Times New Roman'; mso-ascii-font-family: 'Times New Roman'">解釋?zhuān)?lt;/SPAN></B><B><SPAN
lang=EN-US
style="mso-fareast-font-family: PMingLiU; mso-fareast-language: ZH-TW"><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
lang=EN-US>AND</SPAN><SPAN
style="FONT-FAMILY: 宋體; mso-hansi-font-family: 'Times New Roman'; mso-ascii-font-family: 'Times New Roman'">在結(jié)合兩個(gè)布爾表達(dá)式時(shí)，只有在兩個(gè)表達(dá)式都為</SPAN><SPAN
lang=EN-US> TRUE </SPAN><SPAN
style="FONT-FAMILY: 宋體; mso-hansi-font-family: 'Times New Roman'; mso-ascii-font-family: 'Times New Roman'">時(shí)才傳回</SPAN><SPAN
lang=EN-US> TRUE</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><SPAN lang=EN-US><SPAN style="mso-spacerun: yes">
</SPAN>OR</SPAN><SPAN
style="FONT-FAMILY: 宋體; mso-hansi-font-family: 'Times New Roman'; mso-ascii-font-family: 'Times New Roman'">在結(jié)合兩個(gè)布爾表達(dá)式時(shí)，只要其中一個(gè)條件為</SPAN><SPAN
lang=EN-US> TRUE </SPAN><SPAN
style="FONT-FAMILY: 宋體; mso-hansi-font-family: 'Times New Roman'; mso-ascii-font-family: 'Times New Roman'">時(shí)，</SPAN><SPAN
lang=EN-US>OR</SPAN><SPAN
style="FONT-FAMILY: 宋體; mso-hansi-font-family: 'Times New Roman'; mso-ascii-font-family: 'Times New Roman'">便傳回</SPAN><SPAN
lang=EN-US> TRUE</SPAN><B><SPAN lang=EN-US
style="mso-fareast-font-family: PMingLiU; mso-fareast-language: ZH-TW"><O:P></O:P></SPAN></B></P>
<P class=MsoNormal><B><SPAN
style="FONT-FAMILY: 宋體; mso-hansi-font-family: 'Times New Roman'; mso-ascii-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>
<H2><SPAN lang=EN-US
style="FONT-SIZE: 8.5pt; mso-fareast-font-family: 宋體; mso-fareast-language: ZH-CN"><SPAN
style="mso-spacerun: yes"> </SPAN></SPAN><SPAN lang=EN-US
style="FONT-WEIGHT: normal; FONT-SIZE: 8.5pt; mso-fareast-language: ZH-CN">"Persons"
</SPAN><SPAN
style="FONT-WEIGHT: normal; FONT-SIZE: 8.5pt; FONT-FAMILY: 'Arial Unicode MS'; mso-hansi-font-family: Verdana; mso-ascii-font-family: Verdana; mso-fareast-language: ZH-CN">表中的</SPAN><SPAN
style="FONT-WEIGHT: normal; FONT-SIZE: 8.5pt; FONT-FAMILY: 宋體; mso-hansi-font-family: Verdana; mso-ascii-font-family: Verdana; mso-fareast-language: ZH-CN">原始數(shù)據(jù)</SPAN><SPAN
lang=EN-US
style="FONT-WEIGHT: normal; FONT-SIZE: 8.5pt; mso-fareast-font-family: 宋體; mso-fareast-language: ZH-CN">:</SPAN><SPAN
lang=EN-US
style="FONT-WEIGHT: normal; FONT-SIZE: 10pt"><O:P></O:P></SPAN></H2>
<TABLE style="BACKGROUND: #eeeedd; WIDTH: 100%; mso-cellspacing: 0cm"
cellSpacing=0 cellPadding=0 width="100%" bgColor=#eeeedd border=1>
<TBODY>
<TR>
<TD
style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><B><SPAN lang=EN-US
style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana">LastName</SPAN></B><B><SPAN
lang=EN-US
style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana; 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-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><B><SPAN lang=EN-US
style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana">FirstName</SPAN></B><B><SPAN
lang=EN-US
style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana; 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-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><B><SPAN lang=EN-US
style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana">Address</SPAN></B><B><SPAN
lang=EN-US
style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana; 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-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><B><SPAN lang=EN-US
style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana">City</SPAN></B><B><SPAN
lang=EN-US
style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana; 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-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; PADDING-BOTTOM: 0.75pt; PADDING-TOP: 0.75pt">
<P class=MsoNormal><SPAN lang=EN-US
style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana">Hansen</SPAN><SPAN
lang=EN-US
style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: Verdana; mso-fareast-font-family: 'Arial Unicode MS'; mso-bidi-font-family: 'Arial Unicode MS'"><O:P></O:P></SPAN></P></TD>
<TD
style="PADDING-RIGHT: 0.75pt; PADDING-LEFT: 0.75pt; PADDI?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -