How to SUM a column value in MSSQL

Question

I am new to mssql ,Here I need to SUM a column values.

But in my case have some joins between the tables finally I have a column with 2 rows of output .

What I want to do is I want to SUM the final output of my query.

This is my query :

 SELECT 
               SUM(ESCD.ITEM_QTY) * ((SELECT COLOC_PROD_PRICE
               FROM LOM_LNK_PROD_COMP 
               WHERE  COLOC_PROD_CODE = ITEM_ID)
               /
             ((SELECT LMUL.UOL_CONV_QTY 
               FROM LOM_MST_UOM_LINK AS LMUL

               JOIN LOM_MST_PRODUCT AS LMP 
               ON LMUL.UOL_MAIN_UOM_CODE = LMP.PROD_STOCK_UOM
               AND LMP.PROD_CODE = ESCD.ITEM_ID)/LMUL.UOL_CONV_QTY )) AS 'TOTAL_AMOUNT'



               FROM EC_SHOPPING_CART_DETAIL AS ESCD

               JOIN LOM_MST_UOM_LINK AS LMUL
               ON LMUL.UOL_MAIN_UOM_CODE = ITEM_PACK_SIZE

               WHERE CREATED_BY = 'xyz'
               AND  CHECK_OUT = 'FALSE'
               GROUP BY ITEM_ID,LMUL.UOL_CONV_QTY

Output :

Expected AS :

can anyone help me to solve this .

Answer 1

Try the following:

SELECT
  SUM(X.TOTAL_AMOUNT) AS 'TOTAL_AMOUNT'
FROM
(
 SELECT 
           SUM(ESCD.ITEM_QTY) * ((SELECT COLOC_PROD_PRICE
           FROM LOM_LNK_PROD_COMP 
           WHERE  COLOC_PROD_CODE = ITEM_ID)
           /
         ((SELECT LMUL.UOL_CONV_QTY 
           FROM LOM_MST_UOM_LINK AS LMUL

           JOIN LOM_MST_PRODUCT AS LMP 
           ON LMUL.UOL_MAIN_UOM_CODE = LMP.PROD_STOCK_UOM
           AND LMP.PROD_CODE = ESCD.ITEM_ID)/LMUL.UOL_CONV_QTY )) AS 'TOTAL_AMOUNT'



           FROM EC_SHOPPING_CART_DETAIL AS ESCD

           JOIN LOM_MST_UOM_LINK AS LMUL
           ON LMUL.UOL_MAIN_UOM_CODE = ITEM_PACK_SIZE

           WHERE CREATED_BY = 'xyz'
           AND  CHECK_OUT = 'FALSE'
           GROUP BY ITEM_ID,LMUL.UOL_CONV_QTY
) X;