Query - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Query

Author

Topic

elangovan
Starting Member

6 Posts

Posted - 2006-09-18 : 05:25:45

How to tune this query?

select Distinct (select sum(Number) from Test WHERE flag=0) As Ans1,(select sum(Number) from Test WHERE flag=1) As Ans2
FROm Test Group by flag

Table Structure like this
Number Flag
----------- -----------
1 1
2 1
3 1
4 1
5 1
11 0
12 0
13 0
14 0
15 0

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-09-18 : 05:32:01

[code]SELECT SUM(CASE WHEN Flag = 0 THEN Number ELSE 0 END) Ans1,
SUM(CASE WHEN Flag = 1 THEN Number ELSE 0 END) Ans2
FROM Test[/code]

Peter Larsson
Helsingborg, Sweden

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-09-18 : 05:33:56

What is the expected output ?


Ans1    Ans2
65	15

Try this


select	sum(case when flag = 0 then Number else 0 end),
	sum(case when flag = 1 then Number else 0 end)
from	Test

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-09-18 : 05:35:00

elangovan
Starting Member

6 Posts

Posted - 2006-09-18 : 06:10:04

thanks, its working.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources