sql——去重

group by 和distinct都可以实现去重

牛客网上一题来看：找出所有员工当前(to_date='9999-01-01')具体的薪水salary情况，对于相同的薪水只显示一次,并按照逆序显示

group by方法：

select salary from salaries
where  to_date='9999-01-01'
group by salary 
order by salary desc

distinct 方法：

select distinct salary
from salaries
where to_date='9999-01-01'
order by salary desc

 

结果比较;

还是group by时间少一点，具体参考简书上面一篇文章：

https://www.jianshu.com/p/34800d06f63d