SqlServer2012中LEAD函数简单分析

2019/6/30 17:10:11

编程Tag： SqlServer2012 LEAD

本文主要是介绍SqlServer2012中LEAD函数简单分析，对大家解决编程问题具有一定的参考价值，需要的程序猿们随着小编来一起学习吧！

LEAD函数简单点说，就是把下一行的某列数据提取到当前行来显示，看示例更能解释清楚，先看测试用脚本

DECLARE @TestData TABLE( 
 ID INT IDENTITY(1,1), 
 Department VARCHAR(20), 
 LastName VARCHAR(20), 
 Rate FLOAT 
) 
INSERT INTO @TestData(Department,LastName,Rate) 
SELECT 'Document Control','Arifin',17.7885 UNION ALL 
SELECT 'Document Control','Norred',16.8269 UNION ALL 
SELECT 'Document Control','Kharatishvili',16.8269 UNION ALL 
SELECT 'Information Services','Chai',10.25 UNION ALL 
SELECT 'Information Services','Berge',10.25 UNION ALL 
SELECT 'Information Services','Trenary',50.4808 UNION ALL 
SELECT 'Information Services','Conroy',39.6635 UNION ALL 
SELECT 'Information Services','Ajenstat',38.4615 UNION ALL 
SELECT 'Information Services','Wilson',38.4615 UNION ALL 
SELECT 'Information Services','Connelly',32.4519 UNION ALL 
SELECT 'Information Services','Meyyappan',32.4519 

SELECT * FROM @TestData