SQL

Select：Select  column(s)  from  table  or  Select * from table

Distinct：Select distinct column1，column2  from table

Where：Select column(s) from table Where con 

Or  Select * from table  Where con

Insert into：Insert into table values values  

Or  Insert into table(column) values values

Update：Update table

set re_value1,re_value2

Where con

Delete：Delete from table Where con

Select Top：Select Top N|P (column)  from table

Like：Select * from Table

Where con Like ‘’  (_、[]、^、%)

In：Select * from Table

where con in (values1, values2)

Between and：Select * from Table

where con

between values1 and values2

As：Select  column  As ‘another-name’

from table  As  ‘another-name’

Join：Select  *  from  table1

(inner/left/right/full)  join  table2  on  table1.colum=table2.colum

Union：Select column1 from table1

          Union （all）

          Select column2 from table2

Select into：Select * into bu_table from table   

               Or  Insert into bu_table(exist)  select * from table

Create Database：Create database base-name

On primary()

Log on ()

Drop：Drop database base-name

Create Table：Create table table-name ()

Drop：Drop table table-name

Truncate: Truncate table table-name

Alter：Alter table table-name    Alter table table_name         Alter table table-name

             Add column-name style   Alter COLUMN column-name style   Drop COLUMN column-name

View：Create View view-name as    Alter view view-name as      Drop view view-name

            Select * from…                        select * from…

Cast/Convert：select cast(values as style)            select convert(style , values)

IS (NOT) NULL：Select * from table where  column  IS  (NOT)  NULL

Group by：Select column from table where con Group by column

Having：Select column from table

where con

Group by column

Having aggre(column)     for where can’t aggregate in column

Func:AVG/COUNT/FIRST/LAST/SUM/MAX/MIN/LEN/MID/Lcase/Ucase

              MID：Select  MID(column，start，length)  from  table