Forum Discussion
Solved
Using top-nested but not sure if I'm doing it right
Hi,
Hope this is an OK place for a Kusto Query language question...
Given some data, where there might be multiple versions of the same data, for instance:
+----+---------+-----...
- Try using "summarize arg_max()" : https://docs.microsoft.com/en-us/azure/kusto/query/arg-max-aggfunction
Yoni
Microsoft
MicrosoftTry using "summarize arg_max()" : https://docs.microsoft.com/en-us/azure/kusto/query/arg-max-aggfunction
Yoni - thank you! Works perfectly. For everyone else, this achieves the same results as my original one, but much cleaner and faster:
TableName | summarize arg_max(Version,*) by ID
