2011/02/28

Combine use of "group_concat" and "having" inside "group by"

select count(*),sum(sale_price),REPLACE(group_concat(sales_id),',','<br/>') from ebay_sold
group by sale_date
having sum(sale_price) >100

沒有留言:

發佈留言