Summary
SQL Server provides a way to select any one row from a group of rows, provided you write the statement using a specific syntax. This method returns any one row from each group, not the minimum, maximum or anything else. In principle, the one row chosen from each group is unpredictable.
There have been problems with the SelSeqPrjToAnyAgg optimizer transformation used.
The table below summarises the current situation:
For details, read the full article on 𝕏.
No comments:
Post a Comment
All comments are reviewed before publication.