mysql中为同一张表取多个别名&为某一列取别名

169 阅读 0 评论 112 点赞

我是靠谱客的博主朴实鸭子，这篇文章主要介绍mysql中为同一张表取多个别名&为某一列取别名，现在分享给大家，希望可以做个参考。

复制代码

1
2
3
select employee1.name as employee from employee
              employee1,employee employee2 where employee1.managerId=employee2.id and
              employee1.salary>employee2.salary;

这里给同一张表取别名的方法是，

select 列名 as 新列名 from 表名新表名1，表名新表名2；

如果name重复出现，想要在多个name中只保留一个，则在表名前面加distinct；

复制代码

1
2
3
select distinct employee1.salary as employee from employeer
              employee1,employeer employee2 where employee1.id!=employee2.id and
              employee1.salary=employee2.salary ;