Query Question

From: "M(dot) Imran" <imran(at)sdpi(dot)org>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Query Question
Date: 2005-10-10 10:20:47
Message-ID: 01c201c5cd84$4a2568f0$b901a8c0@sdp.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Gary Stainburn 2005-10-10 11:25:27 Update - pg_dumpall money problem
Previous Message Hannes Dorbath 2005-10-10 10:08:29 Re: character problem