Q:

Column Split Sum over a single ID

Similar to a question I had earlier
Having this table
ID, Year, Revenue 
1, 2009, 10 
1, 2009, 20 
1, 2010, 20 
2, 2009, 5 
2, 2010, 50
2, 2010, 1

Is it possible to make a query that results in something similar to this?
ID 2009 2010
1  30   20        
2  5    51

A:

You want to use PIVOT
Look here.
And here: How can i use pivot?
Update
With the new info (Teradata DB), here's the solution:
select 
  ID,
  Sum(CASE When Year = 2009 then Revenue ELSE 0 END) as Y2009,
  Sum(CASE When Year = 2010 then Revenue ELSE 0 END) as Y2010
From
  YourTable
Group by ID

