select * from emp as p where rowid<(select max(rowid) from emp s where

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

Answer Posted / sivakrishna

select * from emp as p where rowid<(select max(rowid) from
emp s where p.deptno=s.deptno);

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

what are the devoleper roles in real time? plz tell i am new to datastage....

2101

What are the components of ascential data stage?

1113

What are the different types of lookups in datastage?

1006

Is the value of staging variable stored temporarily or permanently?

933

Explain ibm infosphere information server and highlight its main features?

1036

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

3213

AGGREGATOR default datatype

1389

What are orabulk and bcp stages?

1069

What are the processing stages?

1041

What are the job parameters?

1161

Differentiate between hash file and sequential file?

1000

Why we use surrogate key?

1159

Enlist various types of routines in datastage.

1185

What are the functionalities of link partitioner and link collector?

952

What is use Array size in datastage

1721