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

Answer Posted / malli

select max(sal) from emp where sal<(select max(sal) from emp);

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is update query?

551


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

531


How do I view a sql database?

564


How would you reference column values before and after you have inserted and deleted triggers?

627


What is function and procedure?

572






Can we join 3 tables in sql?

502


What is output spooling in sql*plus?

557


When can we use the where clause and the having clause?

585


What does truncate mean in sql?

538


What are the 3 types of behavioral triggers?

679


how many groups of data types? : Sql dba

569


what is heap table? : Sql dba

612


Is ms sql is free?

535


What is a natural join sql?

515


Explain the uses of a database trigger?

576