Multiplication of two colomns

Question

My table is bellow productId productQty productRate 1 10 100 2 20 200 3 30 300 4 40 400 5 50 500 I want @qtyRate = productQty* productRate then sum the @qtyRate using sqlserver 2005

Dorababu Meka · Answer

Hi does this query resolved

Dorababu Meka · Answer

Try this select (Rate*Qty) as qtyRate from tblName UNION ALL select sum(Rate*Qty) as qtyRate from tblName will display the multiplied results and sum of multipled result

Dorababu Meka · Answer

Hi one question do you want to display results individually or in result only

Dorababu Meka · Answer

For multiplication use this select ProductQty  ProductRate  ( ProductQty * ProductRate ) as result from table name