《学习SQL语句》——第五天

# Write your MySQL query statement below

select a.name as Employee
from Employee as a, Employee as b
where a.managerId = b.id and a.salary > b.salary; 

学会使用内连接，给分表操作。

 

# Write your MySQL query statement below

select distinct(a.email) as Email
from Person as a, Person as b
where a.email = b.email and a.id != b.id;