Ruby on Rails: must appear in the GROUP BY clause or be used in an aggregate function
14638
PostgreSQL -must appear in the GROUP BY clause or be used in an aggregate function
158751
Oracle ORA-00979 - "not a GROUP BY expression"
84825
In SQL, what's the difference between count(column) and count(*)?
36454
Can you use an alias in the WHERE clause in mysql?
146077
Postgres view column references
155290
Subquery Returned More Than 1 Value with the Group By
48516
How to count occurrences of one field grouped by values of another?
153316
Renaming the created_at, updated_at columns of ActiveRecord/Rails
127084
Returning the 'last' row of each 'group by' in MySQL
109912
PostgreSQL: Generate a series of dates for each group in a table
144271
Use SUM In Update Statement
117739
How to filter SQL results in a has-many-through relation
60950
How to group by DESC order
102054
Is there an Oracle SQL query that aggregates multiple rows into one row?
7999
MySQL: View with Subquery in the FROM Clause Limitation
92398
Should all queries where you expect a specific order, include an ORDER BY clause?
99888
Best way to simulate "group by" from bash?