 |
| |
[.NET]
รบกวนช่วยหน่อยค่ะ เรื่อง หาผลรวมข้อมูล (sum) ค่ะ |
| |
 |
|
|
 |
 |
|
แบบนี้ไหมอะครับ ไม่รู้เออเร่อปล่าว ไม่ได้ลองใน SQLSERVER
Code (SQL)
01.SELECT EMPLOYEE.MEMP ,
02.EMPLOYEE.MPNAME + CHAR(9) + EMPLOYEE.MFNAME + CHAR(9) AS NAME ,
03.EMPLOYEE.MFLASTNAME,
04.EmployeeDT.SAVINGDEP , Interest.MINTEREST ,EmployeeDT .FUND
05.,
06.SUM(Interest.MINTEREST) AS SUM_MINTEREST
07.
08.FROM Interest
09.INNER JOIN EMPLOYEE ON EMPLOYEE.MEMP = Interest.MEMP
10.
11.INNER JOIN EMPLOYEEDT ON EMPLOYEE.MEMP = EMPLOYEEDT.MEMP
12.
13.
14.WHERE Interest.YEAR = '2557'
15.GROUP BY EMPLOYEE.MEMP,
16.EMPLOYEE.MPNAME + CHAR(9) + EMPLOYEE.MFNAME + CHAR(9), EMPLOYEE.MFLASTNAME,
17.EmployeeDT.SAVINGDEP , Interest.MINTEREST ,EmployeeDT .FUND
18.ORDER BY EMPLOYEE.MEMP ;
|
 |
 |
 |
 |
| Date :
2014-05-20 11:02:25 |
By :
CPU4Core |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
ได้แล้วค่ะ ขอบคุณพี่ๆมากๆค่ะ
โค๊ด sql แบบนี้ค่ะ
Code (SQL)
1.SELECT EMPLOYEE.MEMP , EMPLOYEE.MPNAME + CHAR(9) + EMPLOYEE.MFNAME + CHAR(9) AS NAME , EMPLOYEE.MFLASTNAME, EmployeeDT .SAVINGDEP , EmployeeDT .FUND ,SUM(Interest.MINTEREST)
2.FROM Interest INNER JOIN EMPLOYEE ON EMPLOYEE.MEMP = Interest.MEMP
3.INNER JOIN EMPLOYEEDT ON EMPLOYEE.MEMP = EMPLOYEEDT.MEMP
4.WHERE Interest.YEAR = '2557'
5.Group by EMPLOYEE.MEMP , EMPLOYEE.MPNAME , EMPLOYEE.MFNAME , EMPLOYEE.MFLASTNAME ,EmployeeDT .SAVINGDEP , EmployeeDT .FUND
6.ORDER BY EMPLOYEE.MEMP ;
|
| |
|
|
| |
| Date :
2014-05-21 09:33:19 |
By :
chariyamat |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
