牛客SQL08找出所有员工具体的薪水salary情况

题目：请你找出所有员工具体的薪水salary情况，对于相同的薪水只显示一次,并按照逆序显示 输入：

drop table if exists  "salaries" ; 
CREATE TABLE "salaries" (
"emp_no" int NOT NULL,
"salary" int NOT NULL,
"from_date" date NOT NULL,
"to_date" date NOT NULL,
PRIMARY KEY ("emp_no","from_date"));
INSERT INTO salaries VALUES(10001,72527,'2002-06-22','9999-01-01');
INSERT INTO salaries VALUES(10002,72527,'2001-08-02','9999-01-01');
INSERT INTO salaries VALUES(10003,43311,'2001-12-01','9999-01-01');

输出

select distinct(salary) from salaries order by salary desc;

耗时