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

Cross Apply vs Inner Join

Language: Editor: Layout:
View schema
Execution time: 0,03 sec, rows selected: 19, rows affected: 11, absolute service time: 0,23 sec, absolute service time: 0,24 sec 
edit mode |  history  | discussion
   col1
1 6
2 1
3 2
4 3
5 NULL
   col1
1 1
2 2
3 1
4 2
5 3
6 NULL
   col1 col1
1 1 2
2 2 4
3 3 3
   col1 col1
1 6 NULL
2 1 2
3 2 4
4 3 3
5 NULL NULL