Dear DBAs

My requirement is :

I have a table with 2 column :

CAROENQUIRYID PARTICIPANTMAPPINGID
============= ====================
66894942 65438974
66894942 65438977
66894942 65493088
66894942 65583883

66894973 65438974
66894973 65438977
66894973 66104270
66894973 66104271


Now i want result :

CAROENQUIRYID PARTICIPANTMAPPINGID
============= ====================
66894942 65438974
66894942 65438977

66894973 65438974
66894973 65438977

Meanse all the caroenquiryid and participantmapping id which is same for
all the enqiry.

Thanks & Regards
Umesh

Oracle LazyDBA home page