彩票网站建设,wordpress emoji,全国优秀施工企业查询,烟台专业做网页的公司此题是查询出销售额最高的人的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);
