Re: How to find records with the same field?

From: "Joost Kraaijeveld" <J(dot)Kraaijeveld(at)Askesis(dot)nl>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to find records with the same field?
Date: 2004-07-20 10:37:50
Message-ID: A3D1526C98B7C1409A687E0943EAC41001EA4A@obelix.askesis.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks everyone for answering. Apparently my question was not clear enough.

I want something like this:

select col1, col2,col3, col4
from table1
where
col1 =col1 and
col2 = col2 and
col3 = col3
order by col4

But if I run this query I get all the records in the table and not just the (double) ones with the same columns.

TIA

Joost

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lars Erik Thorsplass 2004-07-20 10:43:30 Stored procedures and "pseudo" fields..
Previous Message Peter Alberer 2004-07-20 10:03:15 Re: How to find records with the same field?