Tell me one complex query in oracle ?
Answers were Sorted based on User's Feedback
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 |
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 |
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
if the column name in sql override is diff from the column name in source qualifier,what is the impact?
How you count the number of records available at your source?
Define mapplet?
What is confirmed dimension?
which one is better performance wise joiner or look up
enterprise datawarehouse your project phase by phase explain?
Parameter and variable differences
What is a snowflake schema?
Suppose we do not group by on any ports of the aggregator what will be the output?
How to display First letter of Names in Caps?
What are the types of schemas we have in data warehouse and what are the difference between them?