SQL篇-常用sql

group by
下面这条数据专门用来去除重复数据
select * from user where id in(
select min(id) from user where name = ‘aaa’ and pv = 20 and time = ‘7-15’ group by name,pv,time;)
主要：select后面的字段只能跟group by 后面的字段，或者是聚合函数。
case when then相当于if-else语句
case when sex = ‘1’ THEN '男‘ else ‘其他’ end