表名 :SALE
表的属性:good-id,amount,data
good-id:商品属性
amount:销售数量
data:销售日期
请列出某个月销售量前十名的good-id和amount
以及某天销售量前十名的good-id和amount
使用mysql语句
拜托各位高人了
表的属性:good-id,amount,data
good-id:商品属性
amount:销售数量
data:销售日期
请列出某个月销售量前十名的good-id和amount
以及某天销售量前十名的good-id和amount
使用mysql语句
拜托各位高人了
select good-id,sum(amount)
from SALE
where data between '2008-02-01' and '2008-02-29'
order by 2 desc
limit 10;
[align=center]==== 思想重于技巧 ====
[/align]
select good-id,sum(amount)
from SALE
where data = '2008-02-15'
order by 2 desc
limit 10;
[align=center]==== 思想重于技巧 ====
[/align]
FROM SALE
WHERE date
BETWEEN '2008-05-01'
AND '2008-05-31'
GROUP BY good_id
ORDER BY 2 DESC
LIMIT 10 ;
select good_id,sum(amount)
from SALE
where date = '2008-05-14'
GROUP BY good_id
order by 2 desc
limit 10;