SELECT * FROM `salary_table` group by `salary` order by `salary` desc limi

how to find nth highest salary

Question Posted / yoursguna@gmail.com

Answer Posted / yoursguna@gmail.com

SELECT * FROM `salary_table` group by `salary` order by
`salary` desc limit 1,1

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the use of builtinadministrators group in sql server? : sql server security

971

Describe in brief databases and sql server databases architecture.

944

Tell me what is normalization? Explain different forms of normalization?

983

What is the use of “join” in sql server?

1020

What are system databases into sql server (2005/2008)?

956

What are group functions in query statements in ms sql server?

951

What are sql server functions?

939

what is sql server? : Sql server database administration

930

What is sub-query in sql server? Explain its properties.

1043

What is a print index?

843

What is open database communication (odbc)?

1005

Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?

128

Explain can SSRS reports Cache results?

149

How except clause is differs from not in clause?

899

Can we use having clause without group by?

931