Grant

South Africa

Jul
1
awarded Famous Question
Jun
28
awarded Supporter
Jun
6
accepted How do I Select "sales count" for each item and show as "popularity" in Select ALL "design" options MySql statement?
Jun
6
comment How do I Select "sales count" for each item and show as "popularity" in Select ALL "design" options MySql statement?
Perfect, works great, thanks so much!
Jun
6
comment How do I Select "sales count" for each item and show as "popularity" in Select ALL "design" options MySql statement?
Your answer excludes the designs that have no sales!
Jun
6
comment How do I Select "sales count" for each item and show as "popularity" in Select ALL "design" options MySql statement?
Man that is so simple, I had forgotten about temporary tables, was wrestling with creating aliases but you can't read aliases from a main query in a sub-query.
Jun
6
revised How do I Select "sales count" for each item and show as "popularity" in Select ALL "design" options MySql statement?
added 87 characters in body
Jun
6
asked How do I Select "sales count" for each item and show as "popularity" in Select ALL "design" options MySql statement?
May
26
revised How to fetch record by month in MySQL?
added 137 characters in body
May
26
revised How to fetch record by month in MySQL?
added 181 characters in body
May
26
answered How to fetch record by month in MySQL?
May
24
comment Get totals for the same column but where each SELECT alias contains a specific string
Thanks, this also works well, I accepted the answer below as it fits my purpose better. I am using the output to a chart and getting the values in one group works better in my application.
May
24
accepted Get totals for the same column but where each SELECT alias contains a specific string
May
24
comment Get totals for the same column but where each SELECT alias contains a specific string
Great solution, thank you!
May
24
comment Get totals for the same column but where each SELECT alias contains a specific string
So if a column is NULL assign stage 3 to it
May
24
comment Get totals for the same column but where each SELECT alias contains a specific string
status_group | total : NULL = 2, stage 1 = 24, stage 2 = 15
May
24
comment Get totals for the same column but where each SELECT alias contains a specific string
Ah that is a LOT simpler. How can I fix the output if there is for example no stage 3 value.
May
24
comment Get totals for the same column but where each SELECT alias contains a specific string
status field is a VARCHAR containing text as follows this will vary: "We will implement Stage 1 from 07:00 until 22:00 this evening. "
May
24
asked Get totals for the same column but where each SELECT alias contains a specific string
May
11
awarded Popular Question
1 2 3 4 5