执行顺序

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

MosesDon
7 声望1 粉丝