On Mon, Oct 10, 2005 at 03:20:47PM +0500, M. Imran wrote:
> 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
It's not clear what you're trying to do. Could you post a sample
table and data set (CREATE TABLE and INSERT statements) and an
example of the results you'd like to see?
BTW, this seems off-topic for pgsql-admin, which is supposed to be
for discussions of PostgreSQL administration. A more appropriate
list might be pgsql-general, pgsql-novice, or pgsql-sql.
In response to
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2005-10-10 14:27:27|
|Subject: Re: character problem |
|Previous:||From: Hannes Dorbath||Date: 2005-10-10 13:24:42|
|Subject: Re: character problem|