Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

•Re: MySQL question

by merlyn (Sage)
on Mar 28, 2002 at 22:21 UTC ( #155137=note: print w/ replies, xml ) Need Help??


in reply to MySQL question

Of course, what I REALLY want is the title from the document with the greatest version.
Well, in a real database, you'd do that as:
SELECT title FROM atable WHERE version = (SELECT MAX(version) FROM ata +ble)
But since MySQL doesn't have subselects... {heh heh}.

Time to upgrade to PostgreSQL. Better, faster, cheaper, and more powerful. And able to do typical database things as the big boys do them.

-- Randal L. Schwartz, Perl hacker


update: after the later clarification, see my other post "•Re: Re: Re: MySQL question" for a more accurate solution...


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://155137]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others examining the Monastery: (9)
As of 2015-07-03 18:35 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 (55 votes), past polls