find out the second highest salary?
Answer Posted / hiten
select max(sal) from emp where sal not in(select max(sal)
from emp);
| Is This Answer Correct ? | 25 Yes | 2 No |
Post New Answer View All Answers
How to do paging with oracle?
What is index in Oracle?
What is define in oracle?
What are the different pseudo commands? Explain in general?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
What is oracle instant client?
What are the limitations oracle database 10g xe?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
Does oracle charge for java?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
Explain the truncate in oracle?
In the oracle version 9.3.0.5.0, what does each number shows?
Explain implicit cursor.
What is a Garbage Collection? and what is full recursive Garbage collection?
Explain about integrity constraint?