Timeline for Order by values with most incidence
Current License: CC BY-SA 3.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| S Aug 14, 2015 at 15:32 | history | edited | ypercubeᵀᴹ | CC BY-SA 3.0 |
Removed the comma that directly followed the alias 'frequency' in the SELECT statement
|
| S Aug 14, 2015 at 15:32 | history | suggested | ooutwire | CC BY-SA 3.0 |
Removed the comma that directly followed the alias 'frequency' in the SELECT statement
|
| Aug 14, 2015 at 15:30 | review | Suggested edits | |||
| S Aug 14, 2015 at 15:32 | |||||
| Aug 14, 2015 at 14:25 | comment | added | ypercubeᵀᴹ |
yes, you could do that. if you don't want that number (say 5 events for customer A) in the output, you can even remove the count() from the SELECT list and keep it only in the ORDER BY list.
|
|
| Aug 14, 2015 at 14:23 | vote | accept | Hikari | ||
| Aug 14, 2015 at 14:23 | comment | added | Hikari | lol it worked tnx! In fact I replaced row_number() for count() whatsoever. I don't need to count records at all, I need the amount of incidences of each customerID. | |
| Aug 14, 2015 at 14:20 | history | edited | ypercubeᵀᴹ | CC BY-SA 3.0 |
added 197 characters in body
|
| Aug 14, 2015 at 14:10 | history | answered | ypercubeᵀᴹ | CC BY-SA 3.0 |