[SQL] SELECT DISTINCT

[Shavonne Marietta Wijesinghe]

Hello

I have 2 records with the same value. Even when i do a select with DISTINCT, it 
returns me both the records instead of one.

SELECT DISTINCT ON (TE_COGNOME) TE_COGNOME, TE_NOME, N_GEN_TEST, TE_SESSO, 
TE_ATTNASC, TE_LUONASC, TE_INDI, TE_DTNASC, TE_PROVSTATO,  TE_PROV, 
TE_PATERNITA, TE_RICHIESTA FROM MOD48_02 WHERE TE_COGNOME LIKE 'WIJ%' AND 
TRIM(DELETED) IS NULL ORDER BY TE_COGNOME, N_GEN_TEST DESC;

What should I do??


Thanks

Shavonne