[SQLObject] Subquery MAX().

[Ben T. <bt...@gm...>]

What is the most expedient way to do the following?

--
serial = Path.selectBy().max('serial')
return Path.getOne(serial=serial)
---

I would like some SQL like this:

--
select * from path where serial = (select max(serial) from path);
--

Thanks.