sql求积怎么破？
select product_count, product_price from [order] where [user_id]=4078



表里有N行，每行有2列 数量（product_count）、价格（product_price）每行小计怎么求积，


数量、价格 小计
312.80?
813.90?
413.90?
613.90?
210.90?
59.80? sql select
[解决办法]

select  product_count, product_price ,

(product_count * product_price) as money

from [order] where [user_id]=4078

select product_count,
       product_price,
       (product_count*product_price) '小计'
 from [order] 
 where [user_id]=4078

select  product_count, product_price,product_count*product_price '小计' from [order] 

select  product_count as 数量, 
        product_price as 价格,
        product_count * product_price as 小计
from [order] 
where [user_id]=4078