sql语法手册.htm

讲解了sql的基本用法

            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>
          <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">Year</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; 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>
        <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">Pettersen</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">Kari</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">Storgt 
            20</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">Stavanger</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">1960</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><SPAN 
      style="FONT-SIZE: 8.5pt; COLOR: black; FONT-FAMILY: 宋体; mso-hansi-font-family: Verdana; mso-ascii-font-family: Verdana">返回结果</SPAN><B><SPAN 
      lang=EN-US style="FONT-SIZE: 8.5pt; COLOR: black">:</SPAN></B><SPAN 
      lang=EN-US style="FONT-SIZE: 8.5pt; COLOR: black"><O:P></O:P></SPAN></P>
      <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>
          <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">Year</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