Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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.

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


Please Help Members By Posting Answers For Below Questions

What is recovery manager in Oracle?

1108


How many types of table in Oracle?

1172


ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2343


Explain oracle’s server parameter file.

1040


What happens to the indexes if a table is recovered?

1045


What is a subquery?

1191


Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2421


How to invoke the data pump import utility?

1225


How to define an anonymous block?

1245


Why is oracle so popular?

1053


How to export data with a field delimiter?

1085


Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

3018


How to get the Installed Oracle Version Information ?

1188


What is a table index in oracle?

1185


State the various uses of dbcc command?

1104