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 the use of triggers in Java program? I mean where do we use triggers in Java programming?
Explain the use of consistent option in exp command.
What are the different oracle database objects?
Explain the characteristics of oracle dba?
What is using clause and give example?
What happens to the current transaction if a ddl statement is executed?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
What are oracle functions?
Explain the use of rows option in exp command.
What is the minimum client footprint required to connect c# to an oracle database?
what is the difference between restoring and recovering?
How would you best determine why your MVIEW couldnt FAST REFRESH?
What is the difference between translate and replace?
Explain joins in oracle?
What is system global area (sga) in oracle?