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

Correlated subquery in SELECT clause, and rewritten for Netezza

Language: Layout:
absolute service time: 0,4 sec 
edit mode |  history  | discussion
   user_id last_30 between_31_60 between_61_90
1 1234 1 1 1
2 5545 0 0 1
3 9876 0 1 0
   user_id last_30 btwn_31_60 btwn_31_60
1 1234 1 1 1
2 5545 0 0 1
3 9876 0 1 0