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

Finding gaps, NOT EXISTS clause analysis_1_put on a wall

Language: Layout:
View schema
Execution time: 0,02 sec, rows selected: 14, rows affected: 10, absolute service time: 0,19 sec  
edit mode |  history  | discussion
   seqval start_range_seqval_plus_1 filt1 filt2
1 2 3 0 1
2 3 4 1 1
3 11 12 0 1
4 12 13 0 1
5 13 14 1 1
6 31 32 1 1
7 33 34 0 1
8 34 35 0 1
9 35 36 1 1
10 42 43 1 0
   start_range end_range
1 4 10
2 14 30
3 32 32
4 36 41