Click here to Skip to main content
15,892,927 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
C#
Year      Total          YearTotal        Change        % Change
2010	706.000000	1574.000000	44.853800	0.000000
2011	786.000000	1855.000000	42.371900	0.000000
2012	790.000000	2166.000000	36.472700	0.000000
2013	702.000000	2360.000000	29.745700	0.000000
2014	348.000000	882.000000	39.455700	0.000000


In % Change I need Change for current Year - Change Last Year for Example

C#
2010	706.000000	1574.000000	44.853800	0.00
2011	786.000000	1855.000000	42.371900	-2.48
2012	790.000000	2166.000000	36.472700	-5.89
2013	702.000000	2360.000000	29.745700	-6.72
2014	348.000000	882.000000	39.455700	9.71


I need SQL Query for that.

Thanks
Posted
Updated 31-Oct-14 0:21am
v4

1 solution

Refer this link for many solutions : How to get difference between two rows for a column field?
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900