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
How to create a stored program unit?
What are the extensions used by oracle reports?
What is query image?
How to omit columns with default values in insert statement in oracle?
What is oracle open database communication (odbc)?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
What is the difference between substr and instr?
How to select an oracle system id (sid)?
What is raw datatype in oracle?
Explain oracle insert into command?
How to create a single index for multiple columns?
How to execute the package in oracle?
Explain the difference between replace() and translate() functions in oracle?
What are the execution control statements in oracle?
