On Tue, 18 Sep 2001, Matt Block wrote:
> > echo "SELECT Hauptdaten_Fall.MeldeKategorie, Count
> > (Hauptdaten_Fall.ID) AS Anz FROM Hauptdaten_Fall
> > WHERE (((Hauptdaten_Fall.IstAktuell)=20)) GROUP
> > BY Hauptdaten_Fall.MeldeKategorie ORDER BY
> > Hauptdaten_Fall.MeldeKategorie;" | psql ifsgtest > result
>
> I've not yet looked at the rest of the problem, but doesn't
> ORDER BY make GROUP BY redundant? Just an extra sort?
No it doesn´t. I have to do exact this query.
Kind regards
Andreas.