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

 How to use an oracle sequence generator in a mapping?

1078


What operating systems are supported by oracle database 10g xe?

1037


What are the differences between blob and clob in oracle?

1090


What is raw datatype in oracle?

1143


Explain what are the uses of rollback segment?

1018


From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

1070


What is the usage of synonyms?

1146


Why do we need oracle client?

959


what are steps for interface? where is exchange rate defined in which table?

2164


Is there a function to split a string in plsql?

1068


How to define a procedure inside another procedure?

1026


What is system global area (sga) in oracle?

996


How do I start tns listener?

1051


What are group functions in oracle?

1048


How to convert times to characters in oracle?

1027