Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select * from (
- select row_number() over (order by znachenie) as numbering, * from (
- select * from Table_1 where
- znachenie - 1 not in (select top 100 percent * from Table_1 order by znachenie) and
- (znachenie <> (select top(1) * from Table_1))
- union all
- select * from Table_1 where
- znachenie + 1 not in (select top 100 percent * from Table_1 order by znachenie))q )
- ew
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement