Announcement

Collapse
No announcement yet.

sql query

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • sql query

    i want to count the average of the subcat and then display it out.
    this is my sql query, it seems correct to me but i dono why the results are not displayed out.



    SELECT avg(rate_star) as sumrate FROM rate where rate_cat='CheckPoint' and rate_subcat='CCAE' group by rate_subcat


    SELECT rate_ID, rate_cat, rate_subcat, rate_star FROM rate where rate_cat='CheckPoint' and rate_subcat='CCAE' group by rate_subcat

    pls help.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X