补充一下我的代码:
mysql> update salesclerk,(select s_ID,sum(total) as sale from indent where month
(date)='09' group by s_ID) as result
-> set salesclerk.sale=result.sale
-> where (salesclerk.s_ID=result.s_ID);
这是把订单中9月每个售货员的销售额写进售货员表sale中
排名我不会弄,是手动插入的,只知道可以这样查他们的排名(s_ID=2售货员)
select count(1) as rank from salesclerk where sale >= (select sale from salesclerk where s_ID = 2)