知识点

  1. 只显示一次distinct()
  2. 当前where to_date=

代码

select distinct(salary) from salaries
where to_date='9999-01-01'
order by salary DESC