Get Sum of Row in SQL Server

This blog defines the sum of rows in SQL Server.

This blog defines the sum of rows in SQL Server.

CREATE TABLE EmployeeSalary

(
      ID INT PRIMARY KEY NOT NULL,
      NAME varchar(50),
      BASIC INT,
      HRA INT,
      BONUS INT
)

INSERT INTO EmployeeSalary(ID,NAME,BASIC,HRA,BONUS) values (1001,'Manish Agrahari',1000,500,200);

INSERT INTO EmployeeSalary(ID,NAME,BASIC,HRA,BONUS) values (1002,'Amit Singh',1000,500,200);

INSERT INTO EmployeeSalary(ID,NAME,BASIC,HRA,BONUS) values (1003,'Bill Gates',2000,800,300); 

INSERT INTO EmployeeSalary(ID,NAME,BASIC,HRA,BONUS) VALUES (1004,'Raju Rastogi',2000,800,500);

SELECT * FROM EmployeeSalary

SELECT ID,NAME, BASIC,HRA,BONUS,(BASIC+HRA+BONUS)as Total_Salary

FROM EmployeeSalary