3月2日三道SQL 一道算法 和归并模板181. 超过经理收入的员工SELECT a.Name AS 'Employee'FROM Employee AS a, Employee AS bWHERE a.ManagerId = b.Id AND a.Salary > b.Salary;82. 查找重复的电子邮箱select Email from( select Email, count(Email) as num from Person group by Email) as statisticwhere num > 1;183. 从不订购的客户select Customers.name as 'Customers'from Customerswhere Customers.id not in( select Customerid from orders);剑指 Offer II 005. 单词长度的最大乘积 暴力没做出来 直接看题解将所有的字母等价替换为二进制编码 分别在0-25的位置 判断是否有重复字母只需要判断相与是否为0思路有点牛最近看面经看别人考了 归并算法 默写一下模板