Postgres 10

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

Create table bank2001(
  id integer not null,
  dates date,
  asset integer not null);
insert into bank2001(id,dates,asset) values
  (1,'2001-6-30', 333860),
  (1,'2001-9-30',349343),
  (2,'2001-6-30',451297),
  (2,'2001-3-31',411421),
  (2,'2001-9-30',411421),
  (3,'2001-6-30',106506),
  (3,'2001-3-31',104196),
  (3,'2001-9-30',106383);
8 rows affected

SELECT 
    DISTINCT(id), SUM(asset) AS mv 
FROM 
    bank2001 
WHERE 
    asset NOT IN (SELECT 
                     MAX(asset) 
                  FROM 
                     bank2001)
GROUP BY
     id


id
mv


2
822842

3
317085

1
683203