选择：select * from table where 范围
插入：insert into table(field1,field2) values(value1,value2)
删除：delete from table where 范围
更新：update table set field1=value1 where 范围
查找：select * from table where field1 like ’%value1%’
排序：select * from table order by field1,field2 [desc]
总数：select count as totalcount from table
求和：select sum(field1) as sumvalue from table
平均：select avg(field1) as avgvalue from table
最大：select max(field1) as maxvalue from table
最小：select min(field1) as minvalue from table
更多查看：http://thank123.net/Arc-arcRead-20140125283.html
AD：设主页、装软件， 终身领工资！http://jifen.2345.com/?i4632704
最佳答案
