select id,count(*) from <table name> group by id having count(*)>

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 / sambu

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

Please Help Members By Posting Answers For Below Questions

What is the scenario which compels informatica server to reject files?

1065

How can informatica be used for an organization?

1211

Define mapping and session?

1032

What is Index Caches size?

1110

How can we use batches?

1024

difference between informatica 8.1.1 and 8.6

3673

How can we use mapping variables in informatica? Where do we use them?

1191

Differentiate between Load Manager and DTM?

2151

Separate from an archive server and a powerhouse?

955

Differentiate between source qualifier and filter transformation?

1572

How to join three sources using joiner? Explain though mapping flow.

1142

What do mean by local and global repository?

1224

What is a node in Informatica?

1037

How can you define user defied event?

1026

What is meant by a domain?

1122