weixin_43170297的博客

select d.name as Department, e.Name as Employee, Salary from Employee e join Department d on e.DepartmentId = d.Id where 3 > (SELECT COUNT(DISTINCT e1.Salary) FROM Employee e1 WHERE e1.Salary > e..

select d.Name as Department, e.Name as Employee, Salary from Employee e join Department d on e.DepartmentId = d.id where (e.DepartmentId, Salary ) in (select DepartmentId, Max(Salary) from Employee GROUP by DepartmentId);

4 从不订购的客户select c.Name as Customers from Customers c where id not in (select c.id from Customers c join Orders o on o.CustomerId = c.id);

3 查找重复的电子邮箱:题解: 应用聚合函数havingselect Email from Person group by Email having count(Email) >1;

超过经理收入的员工select e2.Name as 'Employee' from Employee e1 left join Employee e2 on e2.ManagerId = e1.Id where e2.Salary > e1.Salary;

DATEDIFF: DATEDIFF() 函数返回两个日期之间的天数。TIMESTAMPDIFF: