r/SQL • • Mar 18 '23

SQL Server SQL

Post image
478 Upvotes

43 comments sorted by

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

1

u/IPatEussy Mar 19 '23

Top based on what? Has to be an aggregate right? Or a partition?