Cross & Outer Apply

Показать описание

In this video I'll discuss cross/outer apply and when you should use them. I will also show you how they differ from regular joins.

Рекомендации по теме

Комментарии

Been doing SQL for +20 years and bumped into these statements in a query of a colleague. So looked up your explanation. Quite useful functionality. Thanks!

bartvandenpoel

Great video. this really explains clearly and basically how apply operator works and how it works differently to join

KeithyM

Most clear tutorial i've even seen.

charlotxtreme

probably the best explanation AND example for Cross Apply and Outer Apply. Super useful! Can't wait to test it out at work.

supersql

Thank you very much.
I did meet this syntax on procedures I was working on without understanding what it is and I wasn't confident with my understanding of the documentation.
Now I was working on a problem of the same kind as the last example. I did try many things. I had a query that was functionnally OK but the performance was awful.
We have an expert SQL dev in the team and he did me a proposition to solve this, but it is not quite exactly solving the issue but just close and the performance is way better.
Guess it is his way to put me on the way without disclosing the full answer. After all I need to learn that thing.
With your video I understand what it does and what I should do to completely solve the problem.

uchitesting

Clear, articulate, simple. Excellent

salence

Great explanation, thank you. At 9:17 I was thinking "this made a lot of sense, but I wish I could get a final summary of the difference between Cross apply and Outer apply" and then you made that summary doing the last minute!

satori

Such a great video. Excellent explanation. Thank you!

shvideo

Very good explanation! Got to see how it starts with a join, and evolves to apply. Thanks for the good content!

Two questions:

1. Is there any case where we only want to use APPLY over other functions?

2.In the cross apply example that returns top 2 rows for each person, I guess using ROW_NUM() would also work. How would it differ from using apply here? Is it performance wise?

haowen

Thank you for this video, it's the best explanation I've seen.
Question: Is it fair to say that outer apply and left join are interchangeable?

alexintel

Now we can just use merge? Same thing?

chriskeo

Cross & Outer Apply

Cross & Outer Apply

Cross apply and outer apply in sql server

Learn the difference between Cross Apply and Outer Apply in SQL

CROSS APPLY vs CROSS JOIN - when should I use JOINs, and when should I use APPLY?

15- Cross Apply And Outer Apply in SQL Server

CROSS und OUTER APPLY in T-SQL

Cross Apply & Outer Apply in SQL Server

Cross apply and outer apply in sql server

SQL Server CROSS APPLY and OUTER APPLY

The CROSS APPLY and OUTER APPLY | SQL Server

SQL | Cross Apply | When to Use | Difference between Cross Apply and Inner Join

CROSS and OUTER APPLY joins - SQL in 60 seconds #shorts

Outer Apply in Sql Server | Difference between Outer Apply and Left Join in SQL

SQL Server: Cross Apply, Outer Apply, Cross Join

[Advance] Outer Apply and Cross Apply in SQL

Cross apply and outer apply in sql server in arabic

20461C_Mod12_Lab_E2-Writing Queries That Use the CROSS APPLY an OUTER APPLY Operators

cross apply - cool trick in sql server

Cross Apply in SQL Sever || Using Cross Apply operator

SQL Server'da Outer Apply Kullanımı

63. What is difference between Cross Apply and Outer Apply in SQL| SQL Tricky Interview Questions

38 CROSS APPLY and OUTER APPLY P1

Cross Apply & Outer Apply In SQL Server - Apply Operator in SQL Server - ( Hindi / Urdu )

Outer Apply Operator in SQL Server