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

Answer Posted / sushant hole

select max(salary) from employees where salary<(select max(salary) from
employees);

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is partition in sql query?

527


What is write ahead logging in sql server?

572


What are different clauses used in sql?

601


how to enter characters as hex numbers? : Sql dba

584


How do I trace sql profiler?

509






What is a schema? How is it useful in sql servers?

606


How do I run a script in sql developer?

506


How do I make sql search faster?

564


write an sql query to find names of employee start with 'a'? : Sql dba

592


what are the different type of sql's statements ? : Sql dba

526


The in operator may be used if you know the exact value you want to return for at least one of the columns.

567


Does view store data in sql?

546


How do we accept inputs from user during runtime?

561


What is union, minus and interact commands?

757


Can a commit statement be executed as part of a trigger?

611