How to Select second Maximum salary in a Table ?
Answer Posted / kuldeep singh
select max(sal) from emp where sal not in (select top2 sal from emp order by sal desc)
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
How can you merge two tables in oracle?
Define oracle database
Explain the features of oracle?
Explain the difference between a procedure and a function?
What are the ansi data types supported in oracle?
What are the different types of failures that occur in Oracle database?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
How to drop a tablespace?
How to get a list of all background sessions in the database?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
Explain integrity constraint?
What happens to the indexes if a table is recovered?
What is a snapshot in oracle database?
ABOUT IDENTITY?
How do I use os authentication with weblogic jdriver for oracle and connection pools?