最常用的sql語(yǔ)句總結(jié)

1 選擇：

select * from ?table1 where 范圍

2插入:

insert into table1 (field1,field2) values(value1, value2)

3更新:

update table1 set field1=value1 where 范圍

4刪除:

delete from table1 where 范圍

5查找:

select *from table1 where field1 like '%value1%'

6排序:

select * from table1 order by field1.field2 [desc]

7 總數(shù):

select count as totalcount from table1

8求和:

select sum(fieldl) as sumvalue from table1

9平均:

select avg(field1) as avgvalue from table1

10 最大值:

select max(field1) as mxvalue from table1

11最小值

select min(field1) as minvalue from table1