With Limit: nth highest salary Select distinct(salary) from tablename or

please give me the answer for this:
query which generates the second highest integer in the table?

Question Posted / vardhan rao

Answer Posted / vardhan rao

With Limit: nth highest salary

Select distinct(salary) from tablename order by salary desc
limit n-1,1

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to delete a trigger in mysql?

894

What does "i_am_a_dummy flag" do in mysql?

921

What is mysql gpl?

819

What is mysql common?

864

How can you calculate the sum of any column of a table?

1008

How to install mysql?

980

What is a transaction? Describe mysql transaction properties.

1059

How to load data files into tables with 'mysqlimport'?

945

Is mysqli secure?

848

How can you make a database as your current database?

984

Why use stored procedures in mysql?

939

What is difference between Sql server and MySql database? It may be silly question but i really dont know.

2074

What are the security alerts while using mysql?

1004

What is prepared statement in mysql?

923

Why mongodb is faster than mysql?

848