Getting the "latest" related record from a SQL DB

Matt Lawrence matt.lawrence at
Fri Oct 10 17:41:23 BST 2014

On 10/10/14 13:21, David Cantrell wrote:
> On Thu, Oct 09, 2014 at 04:56:22PM +0000, Adam Witney wrote:
>> Could you select all albums, ORDER BY date DESC LIMIT 1 ?
> I don't think that LIMIT is standard SQL so it won't be supported
> everywhere. And also I don't think that useful things like DBIx::Class
> support it.

The feature is very widely supported, but the syntax varies. DBIx::Class 
abstracts that away from you with the 'rows' parameter:


More information about the mailing list