Mysql的where、group by、order by顺 - 玛奇玛丶 - 沸点 - 掘金

java咸鱼工程师

#每天一个知识点# Mysql的where、group by、order by顺序
select * from user
where id >1
group by id having count(*) =1
order by id desc limit 100

展开

赞过