Answer / 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]

Answer / pradip jain

Pivot concept can be use

please correct this as it it near to correct.


SELECT
[2004] '2004',
[2005] '2005',
[2006] '2006'
FROM
(select year,amt from dbo.Pivot1) s
PIVOT
(
sum(amt )
FOR year IN ([2004],[2005],[2006])
) p


output is

2004 2005 2006
10 20 30

Answer / murali krishna reddy

SELECT A.YEAR, (SELECT SUM(AMT) FROM ACCOUNT WHERE YEAR <=
A.YEAR) AS AMT
FROM ACCOUNT AS A GROUP BY A.YEAR

How about this?

What is sql server english query?

0 Answers  

---

what is create database syntax? : Sql server database administration

0 Answers  

---

How do I start sql server 2017?

0 Answers  

---

What is measure group, measure? : sql server analysis services, ssas

0 Answers  

---

I hav 10 records only one column 1,2,3,4,5......10 now am writing query select max(column name) Then What is The Output

9 Answers   Brigade, Wipro,

---

Is candidate a key?

0 Answers  

---

How to use order by with union operators in ms sql server?

0 Answers  

---

write a query for list of owner who are having multiple bikes in below table 1 shanker pulsar 2 shanker Honda 3 shanker car 4 Balu pulsar 5 Balu Honda 6 Balu car 7 Shyam pulsar 8 Jaya Honda 9 Deepa car 10 vasu car

12 Answers   Cognizant, TCS,

---

Can we insert data if clustered index is disabled?

0 Answers  

---

Can I run multiple instances of sql server 2000 at the same time on one computer?

0 Answers  

---

What are ddl triggers and types of ddl trigger?

0 Answers  

---

What are cursors and when they are useful?

0 Answers  

---