Re: Selecting the highest value
Jochen Wiedmann <[email protected]>
| Newsgroups | gmane.comp.db.mysql.perl |
|---|---|
| Message-ID | <[email protected]> |
On 7/28/05, Jan Eden <[email protected]> wrote: > this must be quite simple, but I have no clue how to do it: Can I select the row where a certain column has the highest table of all rows satisfying another where condition? position = MAX(position) might do the trick. Dunno, which version of MySQL supports it, but the latest should do. -- What are the first steps on the moon, compared to your child's? -- MySQL Perl Mailing List For list archives: http://lists.mysql.com/perl To unsubscribe: http://lists.mysql.com/[email protected]