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

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

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Describe link sort?

1015

What are the types of jobs we have in datastage?

1075

How do you generate sequence number in datastage?

1094

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

1252

Explain Quality stage?

1160

How can you write parallel routines in datastage PX?

1015

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

2234

What is use Array size in datastage

1780

table actions available in oracle connector?

1612

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

1008

What is the differentiate between data file and descriptor file?

1363

Differentiate between data file and descriptor file?

1060

AGGREGATOR default datatype

1461

Describe the main features of datastage?

1076

What are the types of views in datastage director?

1775