Skip to Content
0
Nov 12, 2008 at 04:22 AM

How to retain the Duplicate Records

38 Views

Hi All,

I have few Columns in the Report Like

Pnr Number FirstName LastName AirlineCode FareClass ....... etc

A38399 Mark Stephen 178829 Business Class ....

A38399 Mark Stephen 178829 Business Class ....

A38399 Mark Stephen 178829 Business Class ....

A90884 Satheesh K 288282 Economy Class .....

A39494 XJY M 788898 Business Class...

A39494 XJY M 788898 Business Class...

Now what i want is I want to get the data for Mark Stephen and XJY not Satheesh as I want those records which are repeated

more than once ...

I want to retain the records which is repeating more than once .

COUNT >1 but how to do this ?

there are other columns in the Report which is not shown here and have different values so these rows are repeating .

Version :BO XI

DB : Oracle 10g

Hope I am clear.

Regards

Prashant