Sql查询

group by 和having联合使用查询一个表里面重复的字段

SELECT
	station_id
	
FROM
	表
WHERE
	station_id IN ( SELECT station_id FROM station_appraise GROUP BY station_id HAVING count( station_id ) > 1 )

个人感觉having和where大致相同，只不过where无法和合计函数一起使用，比如

SELECT id FROM banner WHERE id > 1 GROUP BY id 

和

SELECT id FROM banner GROUP BY id HAVING  id > 1

一样

case when then end 查询

SELECT 查询的 , #这后面有个逗号
case score
when 5 then '好评'
when 1 then '差评'
else '中评' end
FROM 
station_appraise
GROUP BY CASE score 
when 5 then '好评'
when 1 then '差评'
else '中评' end

排序时，null放在最后面

select * from user u order by u.id is null, u.id

order by 的排序，先排离order by 近的，在排后面的，彼此之间不影响