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
21250 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

How many areas for files does datastage have?

1151

How to perform incremental load in datastage?

1203

Demonstrate experience in maintaining quality process standards?

2549

Lookup constraints

1253

Explain entity, attribute and relationship in datastage?

1095

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

4129

Differentiate between odbc and drs stage?

1050

Difference between in process and inter process?

1229

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

2277

Define Data Stage?

1091

What is quality stage?

987

Does datastage support slowly changing dimensions ?

1103

How many types of hash files are there?

1180

What are the some differences between 7.x and 8.x version of datastage?

1255

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

1111