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