sql语句结构

    1 .查找：select * from table where field1 like ’%value1%’ 所有包含‘value1’这个模式的字符串

　2.排序：select * from table order by field1,field2 [desc]

　3.分组：select * from table group by field1 ORDER BY count(ShopId) LIMIT 20 (兼并排序分页)

　4.总数：select count(*) as totalcount from table

　5.求和：select sum(field1) as sumvalue from table

　6.平均：select avg(field1) as avgvalue from table

　7.最大：select max(field1) as maxvalue from table

　8.最小：select min(field1) as minvalue from table　　

    9. 查询去除重复值：select distinct * from table