sql执行初识

执行顺序

select * from 表1 join 表2 on xxx where xxx group by xxx having xxx order by limit xxx

1. 先关联表 join
2. where
3. group by
4. having
5. select
6. order by
7. limit