Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
consecutive_nums_2
declare @t table ( value int ); insert into @t values ( 1 ), ( 2 ), ( 3 ), ( 9 ), ( 10 ), ( 6 ), ( 7 ); Select *, row_number() over (partition by grp order by value) as newgrp From (Select *, value - row_number() over (order by value) as grp from @t) T
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
Ranking
TESTE PLATAFORMA
Lunes
table emp
SS my sql server 2014 4/7
SQL_Joins_RankingFunctions
SQL for beginners( defined with errors while enforcing constraints)
jueves
QUAN LY CHUYEN BAY
Loading json file into sql server
Please log in to post a comment.