忆龙2009

select a.*, a.lottery_idx - b.lottery_idx as delta_period from dbo.GetAllRecordByResult('555') a left join dbo.GetAllRecordByResult('555') b on a.id = b.id + 1 select a.*, a.lottery_idx - b.lottery_id

use lottery3D if OBJECT_ID('dbo.GetAllRecordByResult','IF') is not null drop function dbo.GetAllRecordByResult; go create function dbo.GetAllRecordByResult(@result nvarchar(3)) retur