select distinct salary from
employee_data order by salary DESC;
+--------+
| salary |
+--------+
| 200000 |
| 120000 |
| 110000 |
| 100000 |
| 90000 |
| 85000 |
| 80000 |
| 75000 |
| 72000 |
| 70000 |
+--------+
10 rows in set (0.01 sec)
mysql> select distinct f_name from employee_data; +---------+ | f_name | +---------+ | Alok | | Anamika | | Arthur | | Danny | | Edward | | Fred | | Ganesh | | Hal | | Hassan | | John | | Joseph | | Kim | | Manish | | Mary | | Mike | | Monica | | Paul | | Peter | | Roger | | Shahida | +---------+ 20 rows in set (0.00 sec)