Cross Apply vs Inner Join, Sql Server

Cross Apply vs Inner Join

Language: 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

λ

                                      .NET NoSQL database for rapid development