Run Code  | Code Wall  | Users  | Misc  | Feedback  | About  | Login  | Theme  | Privacy 

Test row_number() ordering when CTE referenced multiple times

Language: Editor: Layout:
View schema
Execution time: 0 sec, rows selected: 6, rows affected: 0, absolute service time: 0,19 sec 
fork mode |  history  | discussion
   rown id name id_diff
1 1 3 brian 0
2 2 1 john 0
3 3 2 john 0
   rown id name id_diff
1 1 3 brian 0
2 2 1 john 0
3 3 2 john 0