Timeline for How to crosstab with a composite "row name"
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 30, 2017 at 6:24 | vote | accept | lakshman | ||
| Nov 29, 2017 at 20:09 | history | edited | Evan Carroll | CC BY-SA 3.0 |
added 492 characters in body
|
| Nov 29, 2017 at 20:01 | history | edited | Evan Carroll | CC BY-SA 3.0 |
added 40 characters in body
|
| Nov 29, 2017 at 17:03 | comment | added | Evan Carroll |
@DanielVérité it assumes and (now) enforces alphabetical order If he needs natural he should be using date.
|
|
| Nov 29, 2017 at 17:02 | history | edited | Evan Carroll | CC BY-SA 3.0 |
added 11 characters in body
|
| Nov 29, 2017 at 17:00 | comment | added | Daniel Vérité |
I think this assumes that select distinct month... will output the months in the natural order, which it won't generally. Because of that, IHMO crosstab() is not very helpful in this case, whereas a 12-step CASE WHEN month=... THEN sum()... as "month-name" with just a GROUP BY would get the job done.
|
|
| Nov 29, 2017 at 16:42 | history | answered | Evan Carroll | CC BY-SA 3.0 |