Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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 / amrita

Answers were Sorted based on User's Feedback



Hello all, I have data like :- year amt 2004 10 2005 20 2006 ..

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]

Is This Answer Correct ?    2 Yes 2 No

Hello all, I have data like :- year amt 2004 10 2005 20 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

Is This Answer Correct ?    2 Yes 2 No

Hello all, I have data like :- year amt 2004 10 2005 20 2006 ..

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?

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More SQL Server Interview Questions

i need some interview questions on sql server developer plz any onee send some links.

2 Answers  

Describe and explain about SQL native client?

0 Answers  

What is difference between materialized view and view?

0 Answers  

Explain comment on transactions?

0 Answers  

About types of indexes in SQL server ?

2 Answers   Cognizant,

What is the purpose of self join?

0 Answers  

How to drop an existing user defined function in ms sql server?

0 Answers  

Explain data warehousing in sql server?

0 Answers  

What is blocking and how would you troubleshoot it? : sql server database administration

0 Answers  

What do you mean by the term 'normalization'?

0 Answers   Tech Mahindra,

How many types of Cursor in SQL SERVER?

1 Answers  

What are the disadvantages of primary key and foreign key in SQL?

0 Answers   Alcatel-Lucent,

For more SQL Server Interview Questions Click Here
Categories