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
- 5980 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 persistent lookup cache?
How do you update the records with or without using update strategy?
What is a shortcut and copy in Informatica and how two are different with each other?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is a snowflake schema?
What are the designer tools for creating transformations?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is Session and Batches?
what is the size of your data warehousing?
Define the various join types of joiner transformation?
Explain about cumulative Sum or moving sum?
What are multi-group transformations?
How to generate sequence numbers without using the sequence generator transformation?
What are the different clients of powercenter?
