Count needs to appear in the group by our be used in an aggregate
function, if I explictly add the literal 'count_1' as it is aliases to
the group by, the SQL executes, but then the count column is not sum'd
with the literal column and produces unwanted results.
What I need to do is sum the result of the union of the count and
literal columns in the outer select.
Wayne
On Jul 2, 11:39 am, "Michael Bayer" <mike...@zzzcomputing.com> wrote:
> Queb wrote:
>
> > On Jul 2, 10:39 am, "Michael Bayer" <mike...@zzzcomputing.com> wrote:
>
> >> whats count() here, do you mean func.count('*') ?
>
> > Sorry, yes, count('*')
>
> the error you're getting regards "count" needing to appear in the group
> by, which suggests the "count" token you're issuing is incorrect.
>
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
