Run Code  | API  | Code Wall  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

Compare Current Row with Previous row in SQL Server

Language: Layout:
View schema
Execution time: 0 sec, rows selected: 17, rows affected: 17, absolute service time: 0,14 sec 
edit mode |  history 
  
RaidNo
OutComeID
RN
Result



1
2
15
1
0



2
4
15
2
0



3
6
14
3
0



4
8
16
4
1



5
10
16
5
2



6
12
14
6
0



7
14
16
7
1



8
16
15
8
0



9
18
15
9
0



10
20
16
10
1



11
22
12
11
0



12
24
16
12
1



13
26
16
13
2



14
28
16
14
3



15
30
15
15
0



16
32
14
16
0



17
34
13
17
0






    
                		
                
                    

                          
                                
                                
                        
                         



                        
                        
                        

                        

                        
                        

                          
                                
                                
                                  

                                    
λ

                                    

                                      .NET NoSQL database for rapid development