Interested to Buy Any Domain ? << Click Here >> for more details...
5. Display full details for the creditor/s who has received
the single largest payment. Do not use a table join or set
operator anywhere in your query.
- 6 Answers
- 7907 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / srikanth
select *from <TN>
where sal=(select max(sal) from <TN>);
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
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 oracle in java?
What are the different oracle database objects?
query optmization techniques and quwry analyser+projects+ppts
How to check database size in Oracle?
Explain temporal data types in oracle
What is the max number of columns in an oracle table?
What is an oracle recycle bin?
What is a dynamic performance view in oracle?
what is difference between sql plus and sql*plus? (not sql and sql plus).
How to create a single index for multiple columns?
What are joins, explain all types of joins?
What do you understand by a database object? Can you list a few of them?
Give the constructs of a package, function or a procedure.
How to create a new table in your schema?
