name subname price amount
a Aa 100 null
a Aa 90 5
结果
name subname price amount
a Aa 100 5
可能例子不是很恰当，但是我想要的效果就是这样的
求哪位大侠指教一下
------解决方案--------------------
勉强给你拼一个，仅用于你这个例子：
select name ,subname,price,sum(amount) amount
from
(
select name,subname,price,0 as amount
from 表
where amount is null
union all
select name,subname,price, amount
from 表
where amount is not null
)
group by name ,subname,price