另一种使用分区而不使用 group by 陈述

select sum(price.min_price) from 
(select distinct id,min(price) over(partition by id) as min_price from prices) price

我会用相关性 subquery :

select sum(t.price) as overallprice
from table t
where price = (select min(price) from table t1 where t1.id = t.id);

您可以执行如下查询

Select sum (a) from
  (
     Select min (price) as a from yourtable
    Group by id
 ) t

其他一些方法是使用mysql用户变量或自左连接。。
mysql用户变量解决方案
查询

SELECT 
 SUM(prices.Price)
FROM ( 
  SELECT 
     prices.Price
   , CASE 
       WHEN @id != prices.id    
       THEN 1
       ELSE 0 
     END AS isMinGroupValue
   , (@id := prices.id)    
  FROM 
    prices 
  CROSS JOIN (
    SELECT 
      @id := 0
   ) AS init_user_params
  ORDER BY
     prices.ID ASC
   , prices.price ASC 
) AS prices
WHERE
  prices.isMinGroupValue = 1

请参见演示https://www.db-fiddle.com/f/nzwqmqaxd7mvq589r7wuz8/0
自左连接解决方案
查询

SELECT 
 SUM(prices1.Price)
FROM 
 prices prices1
LEFT JOIN
 prices prices2
ON
   prices1.ID = prices2.ID
 AND
   prices1.price > prices2.price
WHERE
 prices2.ID IS NULL

请参见演示https://www.db-fiddle.com/f/nzwqmqaxd7mvq589r7wuz8/1

可以使用子查询选择 min 每个身份证的价格是多少 sum 这些价值观：

select sum(minprice) as overallprice
from (
    select min(price) minprice
    from yourtable
    group by id) t

您可以创建一个子查询来查找每个id的最低价格，并从中获取结果并将它们相加。在伪代码中：

select
  sum(lowest_price)
from (select id, min(price) as lowest_price from prices group by id) lowest_prices