Write a query to get 2nd maximum salary in an employee table ?

Answer Posted / sagar

Select Min(Salary) from Curtest where Salary
in (select Top 2 Salary from Curtest order by salary desc)

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 oracle sql developer?

610


How do I know if I have sql express or standard?

608


Why do we need sharding?

531


Mention what are the benefits of pl/sql packages?

542


how many sql ddl commands are supported by 'mysql'? : Sql dba

531






What does seeding a database mean?

531


How to start oracle sql developer?

564


How can I see all tables in sql?

550


What is sql character function?

546


What is a record in pl/sql?

551


Does postgresql run on the cloud?

593


What are the different types of tables in sql?

487


How do I count duplicates in sql?

552


Are sql database names case sensitive?

505


What kind of join is join?

559