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.

------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and, 
should the need arise, upgrade to a full multi-node Oracle RAC database 
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

Reply via email to