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

Answer Posted / srinivas

select max(salary) from Emp where salary<(select max(salary) from Emp)

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why functions are used in sql?

515


what is top in tsql? : Transact sql

549


What are packages in pl sql and also explain its advantages?

536


how to enter binary numbers in sql statements? : Sql dba

493


Why are indexes and views important to an organization?

529






Why do we use function in pl sql?

563


What is dialect in sql?

527


What is full join in sql?

526


what is the difference between ereg_replace() and eregi_replace()? : Sql dba

558


Does inner join return duplicate rows?

525


What is the basic form of sql query?

499


Describe types of sql statements?

551


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

531


Is natural join and inner join same?

502


Which join condition can be specified using on clause?

517