听起来这就是您要寻找的内容:
select id, dt, pool_name, pool_id, buy_price, (select sum(buy_price) from yourtable) totalfrom yourtable
参见带有演示的SQL Fiddle

听起来这就是您要寻找的内容:
select id, dt, pool_name, pool_id, buy_price, (select sum(buy_price) from yourtable) totalfrom yourtable
参见带有演示的SQL Fiddle