Sum column values and append as last row in SQL Server Query

Prasunje...

SOLVED CLOSED ACTIVE ANSWERED
User: Prasunjeet
Posted: on Mar 13, 2015 08:36 AM
Forum: SQL Server
Answer: 1
Views: 12749

Greetings to every one !

I have some records in a table and i want to show all records from that table after that i want to show the sum of corresponding columns then what will be the sql query for this problem ??

table structure as follows :

	[id] [int] IDENTITY(1,1) NOT NULL,
	[EmployeeID] [nvarchar](50) ,
	[Basic] [float] NULL,
	[GradePay] [float] NULL,
	[SpecialPay] [float] NULL,

id is primary key for this table.

i want result like below :

id EmployeeID Basic GradePay SpecialPay

Download FREE API for Word, Excel and PDF in ASP.Net

Mudassar

0 4

Reply
ANSWER
User: Mudassar
Replied: on Mar 13, 2015 01:39 PM
Report

It is very simple

SELECT Id, SpecialPay FROM MyTable
UNION ALL
SELECT NULL, SUM(SpecialPay) FROM MyTable

You can add more columns and SUM.

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Sum column values and append as last row in SQL Server Query

Company

Explore

Follow us

Contact Us