select EmpName,SalDate,BasicSal,HRA,Total, (select sum(BasicSal)+sum(HRA) from EmpTbl) as SumOfAllSal --subquery From EmpTbl
SELECT EmpName, Sal_Date, Basic_Salry, HRA, Total, SUM(Total) OVER() AS Sum_of_all_Salary FROM myTable;
select EMpName,saldate,basic_Salry,HRA,Total,(select sum(total) from tbl1) as Sum_of_all_summary from tbl1
SELECT Emp, Name, Sal_Date, Basic_Salry, HRA, Total, (SELECT SUM(Total) FROM Table1) AS 'Total Sum_of_all_Salary' FROM Table1
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)