Using SUM along with Union in SQL Query

ganeshms...

SOLVED CLOSED ACTIVE ANSWERED
User: ganeshms87
Posted: on Jul 26, 2012 12:17 AM
Forum: SQL Server
Replies: 1
Views: 2703

Hi sir,

I have following query to retrive sum of column from two more table using union.

select sum(c1) ,null,null from t1

union

select null,sum(c2) ,null from t2

union

select null,null,sum(c3) from t3

Result

-------------

1000 null null

null 2000 null

null null 3000

I want the result as following

1000

2000

3000

How to achieve this?

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

Mudassar

0 1

Reply
User: Mudassar
Replied: on Jul 26, 2012 12:23 AM
Report

I don't understand why are you selecting NULL in the query when you can do following

--CREATE DUMMY TABLE AND INSERT DATA
declare  @t1 table(c1 int)
declare  @t2 table(c2 int)
declare  @t3 table(c3 int)


insert into @t1
select 10
union all
select 29

insert into @t2
select 12
union all
select 21

insert into @t3
select 15
union all
select 22


--SELECT QUERY

select sum(c1) Total from @t1
union
select sum(c2) Total from @t2
union
select sum(c3) Total from @t3

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

Using SUM along with Union in SQL Query

Company

Explore

Follow us

Contact Us