Postgres Pro
Downloads
Home   >   mailing lists

Re: count distinct and group by - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: count distinct and group by
Date
Msg-id mifg9o$d8g$1@ger.gmane.org
Whole thread Raw
In response to Re: count distinct and group by  (Geoff Winkless <pgsqladmin@geoff.dj>)
Responses Re: count distinct and group by
List pgsql-general
Tree view 
Geoff Winkless schrieb am 07.05.2015 um 12:39:
> in Postgres (unlike MySQL) you can't order a list of values by a column you haven't selected.​

Of course you can, just not when you are aggregating.

pgsql-general by date:

Previous
From: Szymon Guz
Date:
Subject: Re: count distinct and group by
Next
From: Geoff Winkless
Date:
Subject: Re: count distinct and group by