Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is translate in oracle?
Explain oracle instance.
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
How to write date and time interval literals in oracle?
What is BBED in Oracle?
What are the different types of partitions in oracle?
What do you mean by a database transaction & what all tcl statements are available in oracle?
Why oracle is used?
Will you be able to store pictures in the database?
What is a read write transaction in oracle?
How to use existing values in update statements using oracle?
How to update values in a table in oracle?
What is oracle server autotrace in oracle?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
How to use "while" statements in oracle?
