# Getting LAST record in aggr in ES|QL

**URL:** <https://discuss.elastic.co/t/getting-last-record-in-aggr-in-es-ql/372903>\
**Category:** Elasticsearch\
**Tags:** esql\
**Created:** [January 7, 2025, 5:35pm UTC](https://discuss.elastic.co/t/getting-last-record-in-aggr-in-es-ql/372903 "2025-01-07T17:35:55Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![jfsardon](https://avatars.discourse-cdn.com/v4/letter/j/ac91a4/32.png) [@jfsardon](https://discuss.elastic.co/u/jfsardon)\
**Post date:** [January 9, 2025, 9:23am UTC](https://discuss.elastic.co/t/getting-last-record-in-aggr-in-es-ql/372903/5 "2025-01-09T09:23:55Z")

</div>

Sure ! Here's the request :  
`FROM logs-connectivity-qyyp | SORT @timestamp DESC | STATS lastState = TOP (stateStatus,1,"asc"), transitionTime=MAX(transitionTime) BY Client, hostname | WHERE lastState LIKE "Failed"`

---

_[View the full topic](https://discuss.elastic.co/t/getting-last-record-in-aggr-in-es-ql/372903)._