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
- 7643 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / aswini
select * from <table_name> where salary in(select max
(salary) from <table_name>);
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Difference between pre-select and pre-query
What are the attributes of the cursor?
What is a dead lock in oracle?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
How to execute a stored program unit?
Is it possible to split the print reviewer into more than one region ?
What is a nested table?
Give the different types of rollback segments.
What is a user role in oracle?
How to connect the oracle server as sysdba?
In oracle there is column command, how will you explain that?
What the is the diff between local index and global index. give some example.
What is meant by a deadlock situation?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
What is a synonym? What are its various types?
