分组聚合查询求和:select 字段1,字段2,sum(求和字段) as 别名 from 表名 where 字段1=‘值’ group by 字段1,字段2;
最大:SELECT * FROM 表名 where 字段=(select max(字段) from 表名 where 字段=‘值’) and 字段=’{值}’;
查询最近一次insrt操作的id(用在insert之后):select @@identity as id
去重查询:SELECT DISTINCT 字段 FROM 表
清空数据表: delete from table_name where 1=1