select * from table1 where id in (select id from table1 group by id having

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

Answer Posted / sivaprakasam

select * from table1 where id in (select id from table1
group by id having COUNT(id) > 1)

Is This Answer Correct ?

29 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What all the types of jobs you developed?

1113

How to perform incremental load in datastage?

1121

Where do you see different stages in the designer?

1034

Describe routines in datastage? Enlist various types of routines.

954

What is difference between server jobs & parallel jobs?

986

What is the difference between server job and parallel jobs?

1091

Name the command line functions to import and export the DS jobs?

1089

What is the flow of loading data into fact & dimensional tables?

1011

Differentiate between hash file and sequential file?

996

What are stage variables?

1136

Define repository tables in datastage?

1098

What is the difference between odbc and drs stage?

1042

Can you explain players in datastage?

1142

What are the steps required to kill the job in Datastage?

1148

Highlight the main features of datastage?

1085