Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

Akoya's scratchpad

by Akoya (Scribe)
on Feb 28, 2008 at 17:18 UTC ( #670943=scratchpad: print w/ replies, xml ) Need Help??

How can I do the same thing this SQL accomplishes using DBIx::Class::Resultset?

select name, ip, environment, type, last_update from test where environment = 'PROD' and last_update in ( select max(last_update) from test where environment = 'PROD' group by type ) order by type

This lists the most recent records for each type for the 'PROD' environment.

Log In?
Username:
Password:

What's my password?
Create A New User
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others wandering the Monastery: (7)
As of 2015-07-08 04:54 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (94 votes), past polls