Answer Posted / vishal
select * from (
select * from test where sal < (select max(sal) from test)
order by 2 desc)
where rownum =1
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How to pass parameters to procedures in oracle?
if you ctreate table identity
What is private procedure oracle?
Where is the export dump file located?
Write a trigger example in oracle?
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
What is meant by raw datatype?
How to use attributes of the implicit cursor in oracle?
Explain parameter file in oracle.
What are the common oracle dba tasks?
What are the uses of Database Trigger ?
Explain what are the uses of rollback segment?
What is the difference between a hot backup and a cold backup in oracle?
What is connection pool in oracle?
What is a tns file?