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