mysql中为同一张表取多个别名&为某一列取别名
select employee1.name as employee from employee employee1,employee employee2 where employee1.managerId=employee2.id and employee1.salary>employee2.salary;这里给同一张表取别名的方...