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

what is update strategy transformation ?

7 Answers   TCS,


What is the function of union transformation?

0 Answers  


What is an Integration service in Informatica?

0 Answers  


What are some examples of informatica etl programs?

0 Answers  


What is ThroughPut in Informatica, How it works, Where I can find this option to check ?

5 Answers   CTS,


please let me know which type of question arise in interview on project manager round on insurance project with answer pls reply asap.

1 Answers   Accenture,


Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

1 Answers   IBM,


Source (Flatfile) - Target (1-1 mapping). How to load first or last 20 record to target?

5 Answers   Flextronics,


how can we load 365 flat file to a single fact table (target) as a history load in single mapping?

2 Answers  


can we generate reports in informatica ? How?

3 Answers  


how to read data from website into informatica? plsss send answers ASAP thanks in advance.

1 Answers   DELL,


I have source like col1,col2,col3,col4 and the values are like 3,6,1,7 1,5,3,8 2,1,5,6 i want the output like 3,6,7 5,3,8 2,5,6 How we will achieve in this scenario in informatica level. Please help me.. Thanks in advance..

4 Answers   Wipro,


Categories