SQL心得

1.多个左接连写

select * from a left join b on a.id=b.id left join c on a.id=c.id;

2.多个内连接连写

select * from a,b,c where a.id=b.id and a.id=c.id;

3.先按ID分组，分组结果再按Name分组

select count(*),id,name from a group by id,name;