Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation
 
PerlMonks  

Re^6: find difference in dates/items in same column

by zerocred (Beadle)
on Nov 15, 2008 at 22:04 UTC ( #723854=note: print w/replies, xml ) Need Help??


in reply to Re^5: find difference in dates/items in same column
in thread find difference in dates/items in same column

Great! 120k rows in 10 seconds on MySQL on Linux and 17 seconds on MS Access
(there's no 'day' parameter mysql's DATEDIFF - when i cracked that it worked!)
select brand, id, date, datediff( date, (select max(T2.date) from test as T2 where T1.brand = T2.brand and T2.date < T1.date) ) from test as T1 order by brand, id
Your solution is vastly superior (simpler/faster) to the one in MYSQL cookbook or any SQL forum/discussion I have seen!
Thanks that's great!

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://723854]
help
Chatterbox?
[Discipulus]: sorry, not able to help erix.. ;=(
[erix]: I guess I'll stare it down in the end but I'm already staring for a while... :)
[erix]: btw, I had a typo in there, so reload (if anyone is looking)

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (8)
As of 2018-01-19 08:15 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    How did you see in the new year?










    Results (216 votes). Check out past polls.

    Notices?