Forum Discussion

Copper Contributor

Apr 26, 2019

Solved

How to pick up records by taking last record in each group

I am trying to implement similar logic as sql select * from (select ROW_NUMBER() OVER( ORDER BY ColumnName desc) AS RowNum From TableName) temp where RowNum=1 How i can achie...

Yoni
Apr 26, 2019
generally speaking, getting the "last" record in each group can be achieved using "summarize arg_max(..)" or "summarize arg_min(..)".
If you'd interested in providing a sample data set (e.g. using the "datatable" operator), this forum could assist with authoring the query.

relevant links for operators/functions mentioned above:

- https://docs.microsoft.com/en-us/azure/kusto/query/arg-max-aggfunction

- https://docs.microsoft.com/en-us/azure/kusto/query/arg-min-aggfunction

- https://docs.microsoft.com/en-us/azure/kusto/query/datatableoperator

Yoni

Microsoft

Apr 26, 2019

generally speaking, getting the "last" record in each group can be achieved using "summarize arg_max(..)" or "summarize arg_min(..)".
If you'd interested in providing a sample data set (e.g. using the "datatable" operator), this forum could assist with authoring the query.

relevant links for operators/functions mentioned above:

- https://docs.microsoft.com/en-us/azure/kusto/query/arg-max-aggfunction

- https://docs.microsoft.com/en-us/azure/kusto/query/arg-min-aggfunction

- https://docs.microsoft.com/en-us/azure/kusto/query/datatableoperator