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

How to change location of errorlog in SQL?

2 Answers   ABC, IBM,

Explain external key management in sql server 2008

0 Answers  

What command do we use to rename a database?

0 Answers  

What is onf in normalization form?

0 Answers  

Observed that some SP’s / Jobs are processing late, how to troubleshoot to improve performance?

1 Answers  

What do I need to start working with sql studio? : sql server management studio

0 Answers  

What is the purpose of sql profiler in sql server?

0 Answers  

How to see the event list of an existing trigger using sys.trigger_events?

0 Answers  

Rate yourself in .NET and SQL ?

1 Answers   Cognizant, HCL, SunGard,

What function does a database engine serve in the sql server?

0 Answers  

What is the use of @@spid?

0 Answers  

Explain log shipping and mention its advantages.

0 Answers  

For more SQL Server Interview Questions Click Here
Categories