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
What are database links used for?
what is a composite key ? : Sql dba
Can two tables have same primary key?
What is the maximum number of triggers, you can apply on a single table?
What are the benefits of stored procedures?
Differentiate pl/sql and sql?
What are the qualities of 2nf?
How to return an array from java to pl/sql?
How to write a query to show the details of a student from students table whose
What are the key differences between SQL and PL SQL?
Can you skip header records while loading? : aql loader
What are the features of pl sql?
how is myisam table stored? : Sql dba
Is sql between inclusive?
Can cursors be part of a trigger body?