Getting the "latest" related record from a SQL DB

[Matt Lawrence]

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:

   https://metacpan.org/pod/DBIx::Class::ResultSet#rows

Matt