Postgres Pro
Downloads
Home   >   mailing lists

SELECT DISTINCT - Mailing list pgsql-sql

From Shavonne Marietta Wijesinghe
Subject SELECT DISTINCT
Date
Msg-id 00c001c872de$5a7dd000$3102a8c0@dream
Whole thread Raw
Responses Re: SELECT DISTINCT  (Richard Huxton <dev@archonet.com>)
List pgsql-sql
Tree view
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

pgsql-sql by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: comment on COLUMN, broken or misunderstanding?
Next
From: Stuart Brooks
Date:
Subject: Am I wasting my time with partitions?