sql语法手册.htm

SQL语法手册.基本的。大家可以来看看呀！

            style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt">Ola<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<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<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<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<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<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<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">Pettersen<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">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 
      style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">选出字段名</SPAN><SPAN 
      lang=EN-US>”</SPAN><SPAN lang=EN-US style="FONT-SIZE: 9.5pt"> 
      LastName</SPAN><SPAN lang=EN-US>”</SPAN><SPAN 
      style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">、</SPAN><SPAN 
      lang=EN-US>”</SPAN><SPAN lang=EN-US style="FONT-SIZE: 9.5pt"> 
      FirstName</SPAN><SPAN lang=EN-US>” </SPAN><SPAN 
      style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">的数据</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 LastName,FirstName FROM Persons<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">:<O:P></O:P></SPAN></P>
      <TABLE bgColor=#eeeedd border=1 cellPadding=0 cellSpacing=0 
      style="BACKGROUND: #eeeedd; WIDTH: 50%; mso-cellspacing: 0cm" 
        width="50%"><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></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 
            style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt">Ola<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<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<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">Pettersen<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">Kari<O:P></O:P></SPAN></P></TD></TR></TBODY></TABLE>
      <P class=MsoNormal><SPAN 
      style="FONT-FAMILY: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'">选出所有字段的数据</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<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">:<O:P></O:P></SPAN></P>
      <P style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-US 
      style="COLOR: black; FONT-SIZE: 8.5pt"><![if !supportEmptyParas]>&nbsp;<![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">
            <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 
            style="COLOR: black; FONT-FAMILY: Verdana; FONT-SIZE: 8.5pt">Ola<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<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<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<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<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<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<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">Pettersen<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">