Home > mailing lists

Query Question - Mailing list pgsql-admin

From	M. Imran
Subject	Query Question
Date	October 10, 2005 10:24:09
Msg-id	01c201c5cd84$4a2568f0$b901a8c0@sdp.org Whole thread Raw
Responses	Re: Query Question
List	pgsql-admin

Tree view

Dear all,

I want to select distinct CODE and thier respective sex, sex can be male/female, can I get my result strictly distinct in code. Currently it duplicate code value for each male and female. I am using this query

select distinct(code), id from table

Regards,

imran

pgsql-admin by date:

From: Hannes Dorbath
Date: 10 October 2005, 09:05:50
Subject: Re: character problem

From: Hannes Dorbath
Date: 10 October 2005, 10:35:52
Subject: Re: character problem

Query Question - Mailing list pgsql-admin

Previous

Next