Test row_number() ordering when CTE referenced multiple times, Sql Server

Test row_number() ordering when CTE referenced multiple times

Language: Layout:

View schema
Execution time: 0 sec, rows selected: 6, rows affected: 0, absolute service time: 0,19 sec

fork mode | history | discussion

  
rown
id
name
id_diff

1
1
3
brian
0

2
2
1
john
0

3
3
2
john
0


  
rown
id
name
id_diff

1
1
3
brian
0

2
2
1
john
0

3
3
2
john
0

λ

                                      .NET NoSQL database for rapid development