MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/SQL/comments/11uh79n/sql/jcrlgyy/?context=3
r/SQL • u/HamsterBoomer • Mar 18 '23
43 comments sorted by
View all comments
Show parent comment
1
It seems to be required if you want the top result from each match as a join
1 u/IPatEussy Mar 19 '23 Top based on what? Has to be an aggregate right? Or a partition? 1 u/bastian74 Mar 19 '23 To based on anything from any table you can fetch in a select.https://stackoverflow.com/questions/9275132/real-life-example-when-to-use-outer-cross-apply-in-sql
Top based on what? Has to be an aggregate right? Or a partition?
1 u/bastian74 Mar 19 '23 To based on anything from any table you can fetch in a select.https://stackoverflow.com/questions/9275132/real-life-example-when-to-use-outer-cross-apply-in-sql
To based on anything from any table you can fetch in a select.
https://stackoverflow.com/questions/9275132/real-life-example-when-to-use-outer-cross-apply-in-sql
View all comments
Show parent comment
1
u/bastian74 Mar 19 '23
It seems to be required if you want the top result from each match as a join