Timeline for Outputting results from a conditional row count across multiple tables
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 13, 2017 at 12:40 | history | edited | CommunityBot |
replaced http://codereview.stackexchange.com/ with https://codereview.stackexchange.com/
|
|
| Jun 26, 2014 at 22:40 | history | edited | 200_success |
edited tags
|
|
| Jun 26, 2014 at 21:08 | answer | added | Phrancis | timeline score: 5 | |
| Jun 26, 2014 at 20:06 | comment | added | CodeX | sqlfiddle.com/#!8/03d95/1 - Fiddle by 200_success | |
| Jun 26, 2014 at 20:04 | comment | added | CodeX | The query works fine, "SUM(), COUNT(), AVG(), MIN(), MAX(), etc. are aggregate functions that requires you to specify a GROUP BY, unless you're using them on every column in your SELECT-list" - stackoverflow.com/a/19222737/3754261 | |
| Jun 26, 2014 at 19:49 | comment | added | Phrancis |
Can you run your query? Seems like it's missing GROUP BY clauses which I thought were needed when you are selecting an aggregate function like SUM() or COUNT()...
|
|
| Jun 26, 2014 at 19:38 | history | asked | CodeX | CC BY-SA 3.0 |