How to get last occurence of row matching a set of filters?

Given a set of filters, I want to get the most recent single row, including the timestamp of the row

Eg, -

I have rows, from 1:00 to 4:00.

I ingested a row matching my filter above at 2:00 & 3:00.

I want to make a query that will give me the row at 3:00.

My initial thought was using the Select query.

This seemed like the most straightforward solution.

However, Select doesnt work in a reverse fashion.

So in this case I will be getting the first occurence instead of the last occurence.

Any ideas on how to accomplish the above?