my table has a column `updated_at` (Long), if i wa...
# exposed
d
my table has a column
updated_at
(Long), if i want to retrieve the "highest value" (order by updated_at desc) and limit it to 1 result - what would be the best approach? so far i'm using
dao.wrapRows(dao.dependsOnTable.select {...}.orderBy(table.updated_at, false).limit(1)).singleOrNull()
- i assume if i'd pull the order_by and limit out of the query statement (and do it after the query's execution) the execution time on the database would increase since it has to fetch all rows and pass them to the app