Tell me one complex query in oracle ?

Answers were Sorted based on User's Feedback



Tell me one complex query in oracle ?..

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

Tell me one complex query in oracle ?..

Answer / mahaboob basha

select users.user_id, users.email, max(classified_ads.posted)
from users, classified_ads
where users.user_id = classified_ads.user_id
group by users.user_id, users.email
order by upper(users.email);

Is This Answer Correct ?    0 Yes 4 No

Post New Answer

More Informatica Interview Questions

hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.

10 Answers  


while creating the scd mappings. we will mention flag value. what exactly the use of defining the FLAG VALUE. Please explaine indetaile

2 Answers   Amdocs,


in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?

2 Answers   Cap Gemini,


According to his methodology what all you need before you build a datawarehouse

0 Answers  


I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.

3 Answers  


What are the different types of code pages available in informatica & how to implement it in your project?

1 Answers   TCS,


In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?

3 Answers   emc2,


write sql query following table city gender no chennai male 40 chennai female 35 bangalore male 25 bangalore female 25 mumbai female 15 i want the required output city male female chennai 40 35 bangalore 25 25 mumbai 15

5 Answers   Tech Mahindra,


Filter transformation in the condition one of the data is NULL would the record be dropped.

2 Answers  


What is DTM process?

4 Answers  


How we can confirm all mappings in the repository simultaneously?

1 Answers  


how to join the two flatfiles using the joiner t/r if there is no matching port?

5 Answers   Cegedim,


Categories