宜昌网站建设开发费用,北京朝阳区二手房出售,学动漫设计可以做什么工作,网站怎么做免费推广方案此题是查询出销售额最高的人的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(p… 此题是查询出销售额最高的人的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);
