select ((select sum((case when year = '2004' then (amt) else 0

Hello all,
I have data like :-

year amt
2004 10
2005 20
2006 30

Now i want output as:-

2004 2005 2006
10 30 60

but i have to use here group by on year.So, i need a single
query within that i can find.

Question Posted / sagun sawant

3 Answers
5436 Views
I also Faced
E-Mail Answers

Answer Posted / sagun sawant

select ((select sum((case when year = '2004' then (amt)
else 0 end)) from account )) as [2004]
,((select sum((case when year = '2005' then (amt)
else 0 end)) from account )) as [2005]
,((select sum((case when year = '2006' then (amt)
else 0 end)) from account )) as [2006]

Is This Answer Correct ?

2 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Benefits of Stored Procedures?

975

What are the approximate numeric data types?

941

Do you know clustered and non-clustered index?

979

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1064

What are the types of database schema? : sql server analysis services, ssas

1134

What happens to a trigger with multiple affected rows?

947

What is isnull() operator?

1044

Which is the best place or learning center for MS SQL?????In Bangladesh?????

2075

What are ddl triggers and types of ddl trigger?

1040

What are the database roles? : sql server security

1194

What is partitioned view?

902

How do I partition a table in sql server?

1047

How to modify existing triggers using "alter trigger"?

1020

Can we do dml on views?

960

What is the use of custom fields in report?

1000