Forum Discussion
Solved
Remove duplicates from query
Hi, hope somebody can help me as I'm a bit stuck in my understanding of the query language.
So I'm trying to get some creation events for App Services, though there seems to be multiple entries for...
- So does arg_max() does the job? From my understanding is the thing that will work for you.
Thanks Stan, sorry for the bad description.
So my original query to get information about deleted App Services returns multiple events for the deletion of the same App. Though these have the same CorrelationId. Therefore I was trying with my limited knowledge of the query language to only return 1 record that has the same CorrelationId. Though still get all the columns the event contains.
I'm trying to use this to drive a webhook and trigger a runbook to do some house cleaning on both creation and deletion of App Services.
My thinking is that the best way to drive the runbook was to use the query language to filter out all the data that the runbook does not need to make its logic work.
Hopefully this makes more sense?
So does arg_max() does the job? From my understanding is the thing that will work for you.