Getting the "latest" related record from a SQL DB

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


On 10 Oct 2014 18:24, "David Cantrell" <david at cantrell.org.uk> 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?

jona


More information about the london.pm mailing list