Interested to Buy Any Domain ? << Click Here >> for more details...
I am having a table with columns
ID NAME
1 x and the requirement is to get the o/p like this
1 y ID Count(*)
1 z 1 3
2 a 2 2
2 b
3 c
so write a sql query to get the id n how many times its
count of repetition n there u shouldn't get the distinct(i.e
id-3)
Reply as early as possible
- 3 Answers
- 6279 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sambu
select id,count(*) from <table name>
group by id having count(*)>1;
The above gives us desired output
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
Mention some types of transformation?
What is informatica powercenter repository?
What is rank transform?
Explain lookup transformation is active in informatica
What is meant by incremental aggregation?
What are the types of presistent cache in look up tr.
which one is better performance wise joiner or look up
What are the mapping parameters and mapping variables?
How will the document be delivered to me?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is InformaticaPowerCenter?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
How do you migrate data from one environment to another?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What is sequence generator transformation in informatica?
