How to get column value into row header
- by Dharmendra Mohapatra
ID amount year
1 300 02-02-2010 00:00
2 400 02-02-2009 00:00
3 200 02-02-2011 00:00
4 300 22-02-2010 00:00
5 400 12-02-2009 00:00
6 500 22-02-2009 00:00
7 600 02-02-2006 00:00
8 700 02-07-2012 00:00
9 500 08-02-2012 00:00
10 800 09-02-2011 00:00
11 500 06-02-2010 00:00
12 600 01-02-2011 00:00
13 300 02-02-2019 00:00
Desired output
Y1 Y2 Y3 ...........
sum(amount) sum(amount) sum(amount)
Please suggest a approach
Y1 is the year part of the date so my result column would be
2006 2009 2010 2011 2012
600 1300 800 1900 1200
Thanks.
DB- MYSQL, SQL SERVER
Thanks.