dedup maximum value

[reverse]

Assuming there are 2 columns - Date & count and there are duplicates date.

How to dedup on Date and pick the maximum count value ?

2020-02-27  1522
2020-02-27  1680
2020-02-28  1639
2020-02-28  1639
2020-02-29  5
2020-02-29  5

Please guide.

[to4kawa · Accepted solution]

your search
|sort 0 - count
| dedup Date

[reverse]

thank you .. worked like a charm!!!

[reverse]

@Vijeta - buddy .. you around ?