Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group