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

Which is faster mongodb or mysql?

897

How to get data from mysql in php?

902

Is mysql good for large database?

928

What is the command used to create a database using php and mysql?

1147

What is the difference between MyISAM Static and MyISAM Dynamic?

1046

Is mysql relational?

913

What is mysql uuid?

925

What is the difference between mysql and oracle?

967

What are slow queries?

905

change column name and make a unique column so we get no dupes.

984

How set mysql root password?

917

How are mysql timestamps seen to a user?

1020

Does mysql use tcp or udp?

919

What is the difference between database and table?

1004

Who owns mysql database?

1040