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
5224 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

What are different type of Collation Sensitivity?

946

How many replicas are maintained for each SQL Azure database?

140

Difference between Inner vs outer joins?

895

What is function of CUBE ?

971

Do you know what is a linked server in sql server?

968

What are Row versions of DataRow?

978

how can you check the level of fragmentation on a table? : Sql server administration

921

what is the information that can be stored inside a bit column? : Sql server database administration

904

What is dml command?

889

What is field with example?

872

Explain about SQLOS?

949

Explain the properties of a relational table?

980

What is default constraint in ms sql server?

968

Can we add our custom code in ssis?

942

What do you understand by physical_only option in dbcc checkdb?

935