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

Does oracle partitioning improve performance?

947


What is a partition in oracle?

1039


Can we store images in oracle database?

948


What are transaction isolation levels supported by oracle?

997


How to write text literals in oracle?

1021


Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1907


What is a system tablespace and when it is created?

921


can u send the sql dumps to sivakumarr1987@gmail.com plz help me

2997


How to set a transaction to be read only in oracle?

1033


what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2415


Explain about functional dependency and its relation with table design?

954


HI, Please let me know the syllabus for Oracle OCA and OCP Certification

2434


What is the minimum client footprint required to connect c# to an oracle database?

1019


Explain the use of inctype option in exp command.

978


Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1811