Re: Problem writing sql statement....

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  wrote:

> -----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 understand your question:
> 
> SELECT FIELD_1, FIELD_2, COUNT(*)
> FROM A_TABLE
> WHERE SOME_DATE = 'yyyy-mm-dd'
>   AND PRODUCTIONID = nnnn
> GROUP BY FIELD_1, FIELD_2
> HAVING COUNT(*) > 1;
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.6 (GNU/Linux)
> 
> iD8DBQFF1OK9S9HxQb37XmcRAhC9AJ9YKyb2HRhr+FAaWQluMG86lyV6egCgu0LU
> 3KT/s+eq5KKHSYDnpRKuyu4=
> =SgpW
> -----END PGP SIGNATURE-----
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend