Getting the "latest" related record from a SQL DB

Jonathan McKeown jonathan at
Fri Oct 10 17:34:49 BST 2014

On 10 Oct 2014 18:24, "David Cantrell" <david at> wrote:
> I don't think that LIMIT is standard SQL so it won't be supported
> everywhere.

True. {FIRST|NEXT} {ROW|n ROWS} ONLY seems to be in a recent SQL standard
(2008?) but I don't think it or any other idiom is universal.

> And also I don't think that useful things like DBIx::Class
> support it.

Don't know about that.

Is this why so many answers prefer a subSELECT?


More information about the mailing list