LetCode-MSSQL销售分析-I

此题是查询出销售额最高的人的ID
首先我们通过语句查询出最高的销售额

select top 1 sum(price)  from Sales group by seller_id order by sum(price) desc

然后我们通过查询总和的值和 最高销售额相等的ID即可

select seller_id from Sales group by seller_id having sum(price) =(select top 1 sum(price)  from Sales group by seller_id order by sum(price) desc);