phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael McAllister <mmcallis...@homeaway.com>
Subject Re: Using COUNT() with columns that don't use COUNT() when the table is join fails
Date Mon, 19 Sep 2016 17:47:26 GMT
This is really an ANSI SQL question. If you use an aggregate function, then you need to specify
what columns to group by. Any columns not being referenced in the aggregate function(s) need
to be in the GROUP BY statement.

Michael McAllister
Staff Data Warehouse Engineer | Decision Systems
mmcallister@HomeAway.com<mailto:mmcallister@HomeAway.com> | C: 512.423.7447 | skype:
michael.mcallister.ha<mailto:zimmkate@hotmail.com> | webex: https://h.a/mikewebex
[cid:image001.png@01D21273.F8F1C960]
This electronic communication (including any attachment) is confidential.  If you are not
an intended recipient of this communication, please be advised that any disclosure, dissemination,
distribution, copying or other use of this communication or any attachment is strictly prohibited.
 If you have received this communication in error, please notify the sender immediately by
reply e-mail and promptly destroy all electronic and printed copies of this communication
and any attachment.

From: Cheyenne Forbes <cheyenne.osanu.forbes@gmail.com>
Reply-To: "user@phoenix.apache.org" <user@phoenix.apache.org>
Date: Monday, September 19, 2016 at 10:50 AM
To: "user@phoenix.apache.org" <user@phoenix.apache.org>
Subject: Re: Using COUNT() with columns that don't use COUNT() when the table is join fails

I was wondering because it seems extra wordy
Mime
View raw message