| From: | bernhard <bs(at)bit-field(dot)de> |
|---|---|
| To: | Gunnar Oehmichen <oehm8895(at)uni-landau(dot)de>, pgsql-de-allgemein(at)postgresql(dot)org |
| Subject: | Re: Abfrage nach einer Reihe von Jahren |
| Date: | 2013-10-02 10:52:09 |
| Message-ID: | 524BFAD9.10007@bit-field.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-de-allgemein |
Hallo Gunnar,
>
> SELECT
> mzb.land,
> count ( distinct (mzb.samplsite_id))
> FROM
> public.mzb
> WHERE
> EXTRACT (year from mzb.date) = 1999 AND
> EXTRACT (year from mzb.date) = 2000 AND
> EXTRACT (year from mzb.date) = 2001 AND
> EXTRACT (year from mzb.date) = 2002
> GROUP BY mzb.land;
>
OR statt AND?
oder IN (1999, 2000, 2001, 2002)
oder BETWEEN 1999 AND 2002
Gruß
Bernhard
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Kretschmer | 2013-10-02 10:55:38 | Re: Abfrage nach einer Reihe von Jahren |
| Previous Message | Andreas Gaab | 2013-10-02 10:51:35 | Re: Abfrage nach einer Reihe von Jahren |