Beefy Boxes and Bandwidth Generously Provided by pair Networks
go ahead... be a heretic
 
PerlMonks  

Re: MySQL question

by rbc (Curate)
on Mar 28, 2002 at 22:43 UTC ( #155143=note: print w/ replies, xml ) Need Help??


in reply to MySQL question

You could try this ...

1 select D.title, D.doc_num, D.version from junk D, 2 ( 3 SELECT 4 A.doc_num doc_num 5 , MAX(A.version) version 6 from 7 junk A 8 , junk B 9 where 10 A.doc_num = B.doc_num 11 and A.title = B.title 12 and A.version >= B.version 13 group by 14 A.doc_num 15 ) C 16* where D.doc_num = C.doc_num and D.version = C.version
... bleh what a ugly mess.


Comment on Re: MySQL question
Download Code

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://155143]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others scrutinizing the Monastery: (3)
As of 2014-10-25 09:14 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    For retirement, I am banking on:










    Results (142 votes), past polls