Run Code
|
API
|
Code Wall
|
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
n sei o nome (30.10)
Query Anisa YP
№3
Ranking split across tournaments
Creation tables
sql test
jueves
№2
Extracting Id No
QLSV