OTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Ron Johnson
> Sent: Friday, February 16, 2007 9:13 AM
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Problem writing sql statement
>
>
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On 02/16/07 01:
nly to delete
certain duplicates.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Ron Johnson
Sent: Friday, February 16, 2007 9:13 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Problem writing sql statement
-BEGIN PGP SIGNED M
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/16/07 01:44, Bjørn T Johansen wrote:
> Not exactly what I want... I don't know the date or id, I just
> need to find all rows that have the same date and the same id..
SELECT SOME_DATE, PRODUCTIONID, COUNT(*)
FROM A_TABLE
GROUP BY SOME_DATE, PRO
Not exactly what I want... I don't know the date or id, I just need to find all
rows that have the same date
and the same id..
BTJ
On Thu, 15 Feb 2007 16:46:21 -0600
Ron Johnson <[EMAIL PROTECTED]> wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On 02/15/07 15:13, Bjørn T Johanse
am Thu, dem 15.02.2007, um 22:13:31 +0100 mailte Bjørn T Johansen folgendes:
> I have a table that I want to find rows that have the same value in two
> fields, e.g. all rows that have the same date and also the
> same productionid...
> How do I write such an sql statement?
I'm not sure if I un
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/15/07 15:13, Bjørn T Johansen wrote:
> I have a table that I want to find rows that have the same value
> in two fields, e.g. all rows that have the same date and also the
> same productionid... How do I write such an sql statement?
If I unders
