求一SQL语句，两条数据合并为一条
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