SELECT ID,COUNT(*) FROM TABLE1 GROUP BY ID HAVING COUNT(*)>1

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

Question Posted / ruchi

3 Answers
6125 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

Please Help Members By Posting Answers For Below Questions

How we can create indexes after completing the loan process?

1208

What is the difference between Active and Passive transformation?

1150

What's the layout of parameter file (what does a parameter file contain?)?

2383

what are factless facts? And in which scenario will you use such kinds of fact tables.

1808

What are the new features of informatica 9.x at the developer level?

1039

how tokens will generate?

2202

What is incremental aggregation?

1081

How to implement security measures using repository manager?

1177

How is union transformation utilized?

1007

How to partition the Session?

1110

What does command task mean?

1141

what is size of u r database?

2305

What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?

8201

What are the types of caches in lookup? Explain them.

969

Enlist the tasks for which source qualifier transformation is used.

1036