楼主是这个意思么? Select Top 50 Count(销量) From Sale Group By dep order by 销量
sql server刚接触几天,不知道这样对不select top 50 from sale --where 部门 =(select distinct 部门 from sale)这个好像不对,在mysql中可以 where 部门='行销部' order by week_sale desc................. .................没想到其它办法还请老鸟指点!
From Sale
Order by week_sale
Select Top 50 Count(销量)
From Sale
Group By dep
order by 销量
from sale
--where 部门 =(select distinct 部门 from sale)这个好像不对,在mysql中可以
where 部门='行销部'
order by week_sale desc.................
.................没想到其它办法还请老鸟指点!