efcore icon indicating copy to clipboard operation
efcore copied to clipboard
verified publisher icon dotnet

Remove DISTINCT inside MIN/MAX operations

Open ranma42 opened this issue 1 year ago • 0 comments

When a value in a query computed as a MAX or MIN of a subquery, DISTINCT has no effect and can be removed.

Conceptually this is a continuation of https://github.com/dotnet/efcore/issues/31016

ranma42 avatar Aug 20 '24 20:08 ranma42