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
- 6278 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / ruchi
SELECT ID,COUNT(*) FROM TABLE1
GROUP BY ID
HAVING COUNT(*)>1
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What is a transaction control transformation?
Difference between Data and Index Caches?
without table how to come first record only in oracle?
What is a repository manager?
What does update strategy mean, and what are the different option of it?
In which transformation you cannot drag ports into it?
Informatica Checkpoints
Define pmcmd command?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Explain the difference between mapping parameter and mapping variable?
Clarify the aggregator change?
can you please explain me pre session and post session options?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
Define filter transformation?
tell me 5 session failure in real time how can you solve that in your project?
