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

Answer Posted / prathapreddy

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

Is This Answer Correct ?

7 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Can you filter data in hashed file?

3773

What is the purpose of pivot stage?

1168

How to read multiple files using a single datastage job if files have the same metadata?

1252

What is meta stage?

1183

What are the types of containers and how to create them?

980

how can we create rank using datastage?what is the meaning of rank?

8795

Is possible to create skid in dim,fact tables?

2637

How you Implemented SCD Type 1 & Type 2 in your project?

4129

What are the functionalities of link partitioner?

1022

how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

5123

Can you explain repository tables in datastage?

1411

Terminate Activity

1281

What is a datastage job?

1013

which r the connectors used in san?

2188

How to perform incremental load in datastage?

1203