题目:题目描述链接
解答:
SELECT DISTINCT Num As 'ConsecutiveNums'
FROM (
SELECT Num,Count(1) As 'SerialCount'
FROM(
SELECT Id,Num,
row_number() over(order by Id) -
row_number() over(partition by Num order
题目:题目描述链接
解答:
SELECT DISTINCT Num As 'ConsecutiveNums'
FROM (
SELECT Num,Count(1) As 'SerialCount'
FROM(
SELECT Id,Num,
row_number() over(order by Id) -
row_number() over(partition by Num order