[Solved] Display the different salary figures earned by faculty members arranged in descending order [closed]

by


As I understand it you want to have a list of unique salary values in descending order. This is how you can achieve it:

SELECT Salary FROM faculty
group by Salary
order by Salary desc

Alternative:

SELECT distinct(Salary) FROM faculty
order by Salary desc

This will give you all the salaries in descending order. If two people earn 10k, you will only see 10k once.

SELECT Salary FROM faculty
group by FacultyID, Salary
order by Salary desc

This will give you all the salaries grouped by faculty id in descending order with no duplicates within a faculty.

3

solved Display the different salary figures earned by faculty members arranged in descending order [closed]