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 / ajit

select *
from ( select sal from emp order by sal desc)
where rownum <= 1

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is bulk copy or bcp in oracle?

1100


Are truncate and delete commands same? If so why?

1128


How index is implemented in oracle database?

978


How to create an oracle database?

1012


How many types of tables are there in oracle?

1041


How to turn on or off recycle bin for the session?

1082


What are the different oracle database objects?

1075


How to open a cursor variable?

1009


How to rollback the current transaction in oracle?

1038


Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

2293


Compare and contrast between sql and sql server and explain its various functions?

948


What is integrity and what is constraint??Explain with example

2256


Is a rollback possible to any savepoint?

1067


How to rename an existing table?

1099


What is the difference between post-database commit and post-form commit?

1160