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 statement is used in a select query for partial matching?

1247

How to Change a users password from unix shell.

1223

What is the current mysql version?

1105

What is current version of mysql?

1084