in reply to MySQL question
Please forgive me for asking this question here, but in my estimation it seems that there are MANY monks here with extensive database experience.
Your estimation is correct. A lot of us know a big deal about cars, too. But this site isn't the appropriate place for that. Sorry, I --'ed your post.
I'd feel really bad if I only complained without trying to answer your question, so here goes:
Hmm, you didn't really state what data you would expect very clearly.
Maybe it's one of these (untested): SELECT title, doc_num, version FROM foo ORDER BY version DESC LIMIT 1 SELECT title, doc_num, MAX(version) AS maxver FROM foo GROUP BY title +ORDER BY maxver DESC
U28geW91IGNhbiBhbGwgcm90MTMgY
W5kIHBhY2soKS4gQnV0IGRvIHlvdS
ByZWNvZ25pc2UgQmFzZTY0IHdoZW4
geW91IHNlZSBpdD8gIC0tIEp1ZXJk
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: Re: MySQL question
by Kozz (Friar) on Mar 28, 2002 at 22:21 UTC | |
by merlyn (Sage) on Mar 28, 2002 at 22:28 UTC | |
by rbc (Curate) on Mar 29, 2002 at 17:10 UTC |
In Section
Seekers of Perl Wisdom