sql员工薪水总和 [英] sql Sum of Salary of employee

问题描述

朋友，
我有一张桌子，如下所示

Emp名称Sal_Date Basic_Salry HRA总计
A 01-01-2012 1000 10 1010
B 01-01-2012 2000 50 2050
C 03-01-2012 3000 40 3040

我需要输出如下:

Emp名称Sal_Date Basic_Salry HRA总计Sum_of_all_Salary
A 01-01-2012 1000 10 1010 6100
B 01-01-2012 2000 50 2050 6100
C 03-01-2012 3000 40 3040 6100

Hi Friends,
I am Having a table as follows

Emp Name Sal_Date Basic_Salry HRA Total
A 01-01-2012 1000 10 1010
B 01-01-2012 2000 50 2050
C 03-01-2012 3000 40 3040

I need Output as Follows:

Emp Name Sal_Date Basic_Salry HRA Total Sum_of_all_Salary
A 01-01-2012 1000 10 1010 6100
B 01-01-2012 2000 50 2050 6100
C 03-01-2012 3000 40 3040 6100

推荐答案

使用子查询，就像这样

use SubQuery, Like this

select EmpName,SalDate,BasicSal,HRA,Total,
       (select sum(BasicSal)+sum(HRA) from EmpTbl) as SumOfAllSal --subquery
      From EmpTbl

祝您编码愉快！
:)

Happy Coding!
:)

使用覆盖 [ ^ ]子句:

Use the OVER[^] clause:

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

这篇关于sql员工薪水总和的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！