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

采用distinct去重复即可。尽量避免使用group by（如果不熟悉的前提下）