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