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

Answer Posted / mallikarjuna

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

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are two statement types in sql?

540


How to run sql statements through the web interface?

514


Should I use mbr or gpt?

546


What is %s in sql?

572


How do you get column names only for a table (sql server)?

671






What is nosql example?

586


what is 'mysqld'? : Sql dba

546


Is sql open source?

545


what is bdb (berkeleydb)? : Sql dba

574


List and explain the different types of join clauses supported in ansi-standard sql?

827


Are subqueries faster than joins?

579


What is nvarchar max in sql?

585


what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

550


What is the difference between the implicit and explicit cursors?

531


what is the difference difference between procedure and packages

9228