📄 sql语法手册.htm
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<!-- saved from url=(0065)http://www.delphidevelopers.com/learnbooks/SQL_Manual_Chinese.htm -->
<HTML><HEAD><TITLE>SQL语法手册</TITLE><!-- InstanceBegin template="/Templates/Document.dwt" codeOutsideHTMLIsLocked="false" -->
<META content="text/html; charset=gb2312" http-equiv=Content-Type><!-- InstanceBeginEditable name="doctitle" --><!-- InstanceEndEditable --><!-- InstanceBeginEditable name="head" -->
<META content=Word.Document name=ProgId>
<META content="MSHTML 5.00.3821.2800" name=GENERATOR>
<META content="Microsoft Word 9" name=Originator><LINK
href="./SQL语法手册.files/filelist.xml" rel=File-List><!--[if gte mso 9]><xml> <o:DocumentProperties> <o:Author>zhuzhichao</o:Author> <o:LastAuthor>firefox</o:LastAuthor> <o:Revision>2</o:Revision> <o:TotalTime>19</o:TotalTime> <o:Created>2002-11-27T05:51:00Z</o:Created> <o:LastSaved>2002-11-27T05:51:00Z</o:LastSaved> <o:Pages>19</o:Pages> <o:Words>3412</o:Words> <o:Characters>6483</o:Characters> <o:Lines>720</o:Lines> <o:Paragraphs>259</o:Paragraphs> <o:CharactersWithSpaces>23884</o:CharactersWithSpaces> <o:Version>9.2812</o:Version> </o:DocumentProperties></xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:PunctuationKerning/> <w:DrawingGridVerticalSpacing>7.8 磅</w:DrawingGridVerticalSpacing> <w:DisplayHorizontalDrawingGridEvery>0</w:DisplayHorizontalDrawingGridEvery> <w:DisplayVerticalDrawingGridEvery>2</w:DisplayVerticalDrawingGridEvery> <w:Compatibility> <w:SpaceForUL/> <w:BalanceSingleByteDoubleByteWidth/> <w:DoNotLeaveBackslashAlone/> <w:ULTrailSpace/> <w:DoNotExpandShiftReturn/> <w:AdjustLineHeightInTable/> <w:UseFELayout/> </w:Compatibility> </w:WordDocument></xml><![endif]-->
<STYLE>@font-face {
font-family: 宋体;
}
@font-face {
font-family: PMingLiU;
}
@font-face {
font-family: 黑体;
}
@font-face {
font-family: Verdana;
}
@font-face {
font-family: \@宋体;
}
@font-face {
font-family: \@黑体;
}
@font-face {
font-family: \@PMingLiU;
}
@font-face {
font-family: Arial Unicode MS;
}
@font-face {
font-family: \@Arial Unicode MS;
}
P.MsoNormal {
FONT-FAMILY: "Times New Roman"; FONT-SIZE: 10.5pt; MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: justify; TEXT-JUSTIFY: inter-ideograph; mso-style-parent: ""; mso-pagination: none; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt
}
LI.MsoNormal {
FONT-FAMILY: "Times New Roman"; FONT-SIZE: 10.5pt; MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: justify; TEXT-JUSTIFY: inter-ideograph; mso-style-parent: ""; mso-pagination: none; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt
}
DIV.MsoNormal {
FONT-FAMILY: "Times New Roman"; FONT-SIZE: 10.5pt; MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: justify; TEXT-JUSTIFY: inter-ideograph; mso-style-parent: ""; mso-pagination: none; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt
}
H1 {
FONT-FAMILY: "Times New Roman"; FONT-SIZE: 10.5pt; FONT-WEIGHT: bold; MARGIN: 0cm 0cm 0pt; TEXT-ALIGN: justify; TEXT-DECORATION: underline; TEXT-JUSTIFY: inter-ideograph; mso-pagination: none; mso-bidi-font-size: 12.0pt; mso-font-kerning: 1.0pt; mso-style-next: 正文; mso-outline-level: 1; text-underline: single
}
H2 {
COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 14.5pt; FONT-WEIGHT: bold; MARGIN: 6.8pt 0cm; mso-pagination: widow-orphan; mso-fareast-font-family: "Arial Unicode MS"; mso-outline-level: 2; mso-bidi-font-family: "Arial Unicode MS"; mso-fareast-language: ZH-TW
}
P {
FONT-FAMILY: Verdana; FONT-SIZE: 12pt; MARGIN-LEFT: 0cm; MARGIN-RIGHT: 0cm; mso-pagination: widow-orphan; mso-fareast-font-family: 宋体; mso-bidi-font-family: "Times New Roman"; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto
}
CODE {
mso-ascii-font-family: "Arial Unicode MS"; mso-hansi-font-family: "Arial Unicode MS"; mso-fareast-font-family: "Arial Unicode MS"; mso-bidi-font-family: "Arial Unicode MS"
}
PRE {
FONT-FAMILY: "Courier New"; FONT-SIZE: 13pt; MARGIN: 0cm 0cm 0pt; mso-pagination: widow-orphan; mso-fareast-font-family: 黑体; tab-stops: 45.8pt 91.6pt 137.4pt 183.2pt 229.0pt 274.8pt 320.6pt 366.4pt 412.2pt 458.0pt 503.8pt 549.6pt 595.4pt 641.2pt 687.0pt 732.8pt
}
DIV.Section1 {
page: Section1
}
</STYLE>
<!-- InstanceEndEditable -->
<STYLE>TD {
FONT-SIZE: 9pt; LINE-HEIGHT: 25px
}
</STYLE>
</HEAD>
<BODY><A href="http://www.delphidevelopers.com/"><IMG alt=Home border=0
height=60 src="SQL语法手册.files/dd_logo.gif" width=250></A>
<HR color=#ff6600>
<BR>
<TABLE border=0 cellPadding=0 cellSpacing=0 width="100%">
<TBODY>
<TR>
<TD width="12%"></TD>
<TD width="76%"><!-- InstanceBeginEditable name="DocumentBody" -->
<DIV class=Section1 style="LAYOUT-GRID-LINE: 15.6pt">
<H1> </H1>
<DIV align=center><FONT size=6><STRONG><BR>SQL语法手册</STRONG></FONT> </DIV>
<P> </P>
<H1><SPAN lang=EN-US>Select</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><SPAN lang=EN-US><SPAN
style="mso-spacerun: yes"> </SPAN></SPAN><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">从指定表中取出指定的列的数据</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>
<P class=MsoNormal><SPAN lang=EN-US><![if !supportEmptyParas]> <![endif]><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 column_name(s) FROM table_name<O:P></O:P></SPAN></PRE></TD></TR></TBODY></TABLE>
<P class=MsoNormal><SPAN lang=EN-US><![if !supportEmptyParas]> <![endif]><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>
<P class=MsoNormal style="TEXT-INDENT: 21pt"><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">从数据库中选取资料列，并允许从一或多个资料表中，选取一或多个资料列或资料行。</SPAN><SPAN
lang=EN-US>SELECT </SPAN><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">陈述式的完整语法相当复杂，但主要子句可摘要为：</SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US>SELECT select_list <BR>[ INTO
new_table ] <BR>FROM table_source <BR>[ WHERE search_condition ] <BR>[
GROUP BY group_by_expression ] <BR>[ HAVING search_condition ] <BR>[ ORDER
BY order_expression [ ASC | DESC ] ] </SPAN></P>
<P style="MARGIN: 0cm 0cm 0pt"><B><SPAN
style="FONT-FAMILY: 宋体; mso-ascii-font-family: Verdana; mso-hansi-font-family: Verdana">例：</SPAN><SPAN
lang=EN-US><O:P></O:P></SPAN></B></P>
<P style="MARGIN: 0cm 0cm 0pt"><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">表中的数据有</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">
<P class=MsoNormal><B><SPAN lang=EN-US
style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt">LastName<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<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<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<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<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
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -