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
Infrared-to-visible upconversion fluorescence of Er(3+)/Yb(3+) co-doped lithium-strontium-lead-bismuth (LSPB) glasses for developing potential upconversion lasers has been studied under 975-nm excitation. Based on the results of energy transfer effic
