Getting the "latest" related record from a SQL DB
David Cantrell
david at cantrell.org.uk
Fri Oct 10 13:21:53 BST 2014
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.
--
David Cantrell | semi-evolved ape-thing
Good advice is always certain to be ignored,
but that's no reason not to give it -- Agatha Christie
More information about the london.pm
mailing list