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

Find missing record and return adjacent records SQL - without 1

Language: Layout:
View schema
Execution time: 0,02 sec, rows selected: 6, rows affected: 12, absolute service time: 0,17 sec  
edit mode |  history
   BatchId CreateDate UserId Batch PrevSeq BatchSeq NextSeq
1 4L182855 - 2 28.09.2017 15:19:32 4L182855 9 1 2 4
2 4L182855 - 4 28.09.2017 17:57:20 4L182855 9 2 4 5
3 4L182855 - 5 28.09.2017 18:20:57 4L182855 9 4 5 2
4 4L182855 - 2 29.09.2017 11:19:32 4L182855 0 NULL 2 3
5 4L182855 - 8 29.09.2017 12:30:27 4L182855 0 7 8 10
6 4L182855 - 10 29.09.2017 14:20:57 4L182855 0 8 10 NULL

    
                
λ
.NET NoSQL database for rapid development