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...

Tell me one complex query in oracle ?

Answer Posted / prateek

select distinct sal from emp e1 where 3 = (select count(distinct sal) from emp e2 where e1.sal <= e2.sal);

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean incremental aggregation?

1072


Mention a few design and development best practices for informatica?

994


What is union transformation?

961


Explain the difference between a data warehouse and a data mart?

1056


Quickly characterize reusable change?

1117


Explain the different dimensions.

956


can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10677


Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1975


My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1926


Differentiate between a repository server and a powerhouse?

1116


What is the procedure for creating independent data marts from informatica 7.1?

1060


How will the document be delivered to me?

1076


What is the difference between router and filter?

1260


What is a joiner transformation and why it is an active one?

1073


How to extract sap data using informatica?

1042