Beefy Boxes and Bandwidth Generously Provided by pair Networks DiBona
Just another Perl shrine
 
PerlMonks  

Re: Comparing rows keeping latest

by Grygonos (Chaplain)
on Feb 20, 2006 at 15:44 UTC ( [id://531524]=note: print w/replies, xml ) Need Help??

This is an archived low-energy page for bots and other anonmyous visitors. Please sign up if you are a human and want to interact.


in reply to Comparing rows keeping latest

Assuming you're the one writing the query, a simple SELECT MAX(Date) As MaxDate,ID FROM tblFoobar GROUP BY ID will get you exactly what you want. Leaving this problem to Perl is not the best approach IMHO

Grygonos

Replies are listed 'Best First'.
Re^2: Comparing rows keeping latest
by Anonymous Monk on Feb 20, 2006 at 15:53 UTC
    Thanks, I think that should work... I wil have to go look up the syntax. Thanks again all for all your help...
[reply]
      The syntax of the query I provided, should be ANSI compliant. I don't know how much you would need to change.
      Grygonos
[reply]

In Section Seekers of Perl Wisdom

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?

www.com | www.net | www.org
Node Status?
node history
Node Type: note [id://531524]
help
Sections?
Information?
Find Nodes?
Leftovers?
    Notices?
    • hippo‥ epoptai's answer Re: how do I set a cookie and redirect was blessed by hippo!
    • erzuuli‥ Anonymous Monks are no longer allowed to use Super Search, due to an excessive use of this resource by robots.