Sum of two columns

Question

I have a table(itemid itemcodeitemnameunitpartnoqty1qty2price) named item I want to  select itemnamepartnounitsum(qty1+qty2)price from item where itemcode='###'. but it will not work .plz help?

Ravi K Kashyap · Answer

USE THIS SELECT itemname  partno  unit  qty1 + qty2 AS [TOTAL QUANTITY]  price FROM ITEM WHERE ITEMCODE = '###'

Suthish Nair · Answer

you cant' use sum(qty1+qty2).re-write as (qty1+qty2) 'Total'

Jiteendra Sampathirao · Answer

(sum(col1)+sum(col2)) as Column

Sandeep Shekhawat · Answer

select itemnamepartnounit (sum(qty1)+sum(qty2)) as quantity price from item where itemcode='###'