Azure CosmosDb SQL query: Get max of grouped documents

Marc Uhlig 1

Azure CosmosDb SQL query: Get max of grouped documents

GeethaThatipatri-MSFT 29,552 Reputation points Microsoft Employee Moderator

2022-11-23T21:24:45.52+00:00

Hi, @Marc Uhlig Welcome to the Microsoft Q&A platform, thanks for posting the question
I see you have also posted the same question on Stack Overflow,
in your Query you have used MAX -This aggregate function returns the maximum of the values in the expression. however, I will repro and provide you with more details.
Please refer to this document for more information on Group By
what is the result of your second query?

Regards
Geetha
GeethaThatipatri-MSFT 29,552 Reputation points Microsoft Employee Moderator

2022-12-05T14:13:52.327+00:00

Hi, @Marc Uhlig We haven't heard back from you. Just wanted to check if you had the chance to check the document.

Regards
Geetha

Your answer