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
- 6140 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
Explain the use of aggregator cache file?
What is the use of source qualifier?
What are the tuning techniques you applied during your last project
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What are pre and post-session shell commands?
Can you generate sequence numbers without using the sequence generator transformation?
Explain the difference between a data warehouse and a data mart?
What are roles and groups and benefits of using them?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is the difference between writing a joiner query in ANSI style and THETA style?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What are the popular informatica products?
Enlist few areas or real-time situations where informatica is required.
