Mysql学习之路

1.group by 计算的模板： 

select c1,c2....... Count/sum/Avg/Max/Min(case when..then..

when..then.. ..... else... end)

from Table where ..... Group by.... (Having....)

例题：leetcode p182. 从Person表中查找重复的邮箱

select email
from Person
group by email
having count(Email > 1);

2. join(链接两个Table)  注 a = Table_1, b =Table_2, c,d分别为字段

select a.c1,a.c2....... b.d1,b.d2......

from Table_1 a (left/full outer/ inner) join Table_2 b on a.xx = b.xx/ between b.xx and b.xx+3

where .....

例题：leetcode p175 ：两个表的组合

select FirstName,LastName,City,State
from Person left join Address 
on Person.PersonID = Address.PersonID;

3.window function

1. rank

2.累计求和