select v1, v2, v3 from
(
select @v1 as v1, @v2 as v2, value as v3, @v1 := @v2, @v2 := value
from Tab
) as abc
where v1=v2-1 and v2=v3-1相当于下一列中找顺子,但
这里的" @v1 := @v2, @v2 := value "在T-SQL里好像没有相近的写法
(
select @v1 as v1, @v2 as v2, value as v3, @v1 := @v2, @v2 := value
from Tab
) as abc
where v1=v2-1 and v2=v3-1相当于下一列中找顺子,但
这里的" @v1 := @v2, @v2 := value "在T-SQL里好像没有相近的写法
select v1, v2, v3 from
(
select @v1 as v1, @v2 as v2, value as v3, @v1 = @v2, @v2 = value
from Tab
) as abc
where v1=v2-1 and v2=v3-1
这种给变量付值只有在update语句可以更新,在select 语句里没办法更新的
万万没想到 T-SQL 连MySQL里的语法都不支持啊