how to find nth highest salary

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the minimum recommended amount of ram for sql server 2012 enterprise?

600


what is the primary use of the model database? : Sql server administration

604


What are the types of database recovery models?

673


How display code or Text of Stored Procedure using Sql query in Sql Server ?

705


what are the different types of replication you can set up in sql server? : Sql server database administration

614






What is ssrs?

101


What are the different kinds of ssrs reports?

180


What do you mean by recursive stored procedure?

594


What is sql language?

625


What is awe?

670


code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

1859


Explain the various types of concurrency problem?

806


Do you know the isolation level that sql server support?

610


Where are sql server user names and passwords stored in sql server?

625


Explain what is the difference between a local and a global temporary table?

590