<pre name="code" class="sql">select a.Name as Employee
from Employee a Join Employee b on a.ManagerId=b.Id
where a.salary > b.salary;
1.涉及关于字段在查询时的重命名
select column_name as new_column_name
2. 对自身的连接
TableName a joint TableName b on conditions