展开全部-试试下面的sql语句 select b.股票名称,sum(b.收益)已收益,sum(b.持有数量)当前持有数量 from(select 股票名称,(case when a.投资行为='买' then a.交易数量 else(-1)*a.交易数量 end)持有数量,(case when a.投资行为='买' then(-1)*a.交易金额 else a.交易金额 end)收益 from a)b group by b.... 20210311
h**e access to 有机会接近/进入,有权利使用/进入 例句:only a few people h**e access to the full facts of the case. 只有少数几个人能看到有关该案全部事实的材料。the access to somewhere 通道,入口 例句:the only access to their house ** along that nar...