Skip to Content
0
Dec 01, 2009 at 02:31 PM

Detect doubloon records in table

49 Views

Dear All,

I have an external table which contains 75000 records about.

here an example:

NAME | TYPE | VALUE

-


TOTO | BOEING | 10

TITI | BOEING | 20

TATA | DASH | 30

TUTU | AIRBU | 20

TYTY | DASH | 10

I want to display only the records ayant the same value for the field TYPE.

In this case:

TOTO (boeing)

TITI (boeing)

TATA (dash)

TUTU (dash)

How can i proceeed ?

Thanks for your help!

Rodolphe.