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

i have a table
col1
10
20
30
40
10
20
50
my requirement is how to retrive only duplicates like
10
10
20
20
like this how it's possible in SQL?

Question Posted / prathapreddy

11 Answers
20842 Views
Cap Gemini, I also Faced
E-Mail Answers

Answer Posted / prathapreddy

select col1,count(*) from <table name> group by col1 having
count(*)>1;

Is This Answer Correct ?

7 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are constraints and derivations?

1111

Can you highlight the main features of ibm infosphere information server?

1044

What is the use of hoursfromtime() function in transformer stage in datastage?

999

Where do you see different stages in the designer?

1034

Differentiate between datastage and informatica?

1140

Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

2166

Name the different sorting methods in datastage.

989

What is the difference between account and directory options ?

1111

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

751

Have you used Unstructured data?

1266

What is datastage?

1028

Whats difference betweeen operational data stage (ods) and data warehouse?

1069

Which warehouse using in your datawarehouse

2115

Explain datastage architecture?

1332

Which commands are used to import and export the datastage jobs?

1358