如何使用SQL Query在同一列值中查找Diffrents [英] How to find Diffrents in same column Value using SQL Query

问题描述

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我需要更改当前年份 - 更改去年例子

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

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

我需要SQL查询。



谢谢

I need SQL Query for that.

Thanks

推荐答案

请参阅此链接以获取更多解决方案：如何获得列字段的两行之间的差异？

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

这篇关于如何使用SQL Query在同一列值中查找Diffrents的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！