Re: Query Question

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.

--
Michael Fuhr