Mysql salary calculation

I want to display 1st highest,2nd highest,3rd highest ....nth number of employee

salary list in mysql database.

if it is possible please send me that sql query to my email address.

Thanks
Email: ghose098765@gmail.com

 

Do you have a table created ?

 

So you want to add a Order By Salary_Column Descending and then a Limit N to cap the number you want

 

yes, I want to display all the employee list according to 1st highest to nth highest salary? Give me mysql command

 

You cant simply give you the mySQL command, since you have given a table to perform the query upon. But you could possibly have something like this: -

SELECT * FROM table_name ORDER BY salary DESC LIMIT (number)