How to select the latest row in table after refresh

Hi there, i want to select automatically the latest row in table so when i create a invoice at success i added table1.refresh and i want after that to select the row the data are displayed desc by invoice number they are not desc from retool database but added at table to sort desc

Try this in the table itself:
Screenshot 2023-12-27 at 9.36.33 AM

you mean at query where I want to select automatically the latest row in the top to add this at table control components?

In the table component Inspect panel