Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- code | row_number | row_number_partition_by_code | group_number
- ------------------------------------------------------------------
- 0 | 1 | 1 | 0
- 0 | 2 | 2 | 0
- 1 | 3 | 1 | 2
- 1 | 4 | 2 | 2
- 0 | 5 | 3 | 2
- 1 | 6 | 3 | 3
- 0 | 7 | 4 | 3
- 0 | 8 | 5 | 3
- 0 | 9 | 6 | 3
- 0 | 10 | 7 | 3
- 1 | 11 | 4 | 7
- 0 | 12 | 1 | 0
- GROUP BY group_number
- HAVING COUNT(1) > 2
Add Comment
Please, Sign In to add comment