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
6106 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

Whats the difference between informatica powercenter server, repositoryserver and repository?

1168

How can we store previous session logs?

1067

How to create a non-reusable instance of reusable transformations?

1115

Explain the tuning lookup transformation - informatica

988

tell me about your project functionality

2340

server hot-ws270 is connect to Repository B. What does it mean?

2553

What is a pre-defined event and user-defined event?

1036

What do you mean incremental aggregation?

1072

Define mapping and session?

1031

How do you load first and last records into target table?

1152

Design time, run time. If you don't create parameter what will happen

1833

what is the difference between informatica6.1 and infomatica7.1

2267

How to start a workflow using pmcmd command?

1242

How to do the error handling of if ur source is flatfiles?

1962

What is a stored procedure transformation?

1049