Hi vail,
Refer below SQL Query
SQL
DECLARE @OrderIncome AS TABLE (OrderDate DATETIME,OrderNo INT,PaymentMethod VARCHAR(50),Amount FLOAT,OrderClosingDate DATETIME)
INSERT INTO @OrderIncome VALUES(GETDATE(),1,'Online',2538.3,'09/14/2017')
INSERT INTO @OrderIncome VALUES(GETDATE(),2,'Cash',45225,'06/25/2017')
INSERT INTO @OrderIncome VALUES(GETDATE(),3,'Cheque',7585,'01/24/2017')
INSERT INTO @OrderIncome VALUES(GETDATE(),4,'Online',78855,'07/30/2017')
INSERT INTO @OrderIncome VALUES(GETDATE(),5,'Cheque',4545,'02/15/2017')
INSERT INTO @OrderIncome VALUES(GETDATE(),6,'Cash',24554,'09/06/2017')
INSERT INTO @OrderIncome VALUES(GETDATE(),7,'Online',4575,'03/22/2017')
INSERT INTO @OrderIncome VALUES(GETDATE(),8,'Cheque',9886,'07/11/2017')
INSERT INTO @OrderIncome VALUES(GETDATE(),9,'Online',7878,'10/14/2017')
DECLARE @Cash VARCHAR(50)
DECLARE @Online VARCHAR(50)
DECLARE @Cheque VARCHAR(50)
SET @Cash = (SELECT SUM(Amount) FROM @OrderIncome WHERE PaymentMethod = 'Cash')
SET @Online = (SELECT SUM(Amount) FROM @OrderIncome WHERE PaymentMethod = 'Online')
SET @Cheque = (SELECT SUM(Amount) FROM @OrderIncome WHERE PaymentMethod = 'Cheque')
SELECT @Cash 'Cash',@Online 'Online',@Cheque 'Cheque'
Output
Cash |
Online |
Cheque |
69779 |
93846.3 |
22016 |