Equivalent expressions

[Thomas Bartkus]

Given a primary key field `RecNo` -

Are there any performance reasons to favor one of these two otherwise
equivalant expressions?

SELECT MAX(RecNo)
FROM SomeTable;

SELECT RecNo
FROM SomeTable
ORDER BY RecNo DESC
LIMIT 1;

Just curious.
Thomas Bartkus

[strawberry]

Thomas Bartkus wrote:

Given a primary key field `RecNo` -

Are there any performance reasons to favor one of these two otherwise
equivalant expressions?

SELECT MAX(RecNo)
FROM SomeTable;

SELECT RecNo
FROM SomeTable
ORDER BY RecNo DESC
LIMIT 1;

Just curious.
Thomas Bartkus

I think the performance differences (if any) would be easy enough to
test yourself.
Note though that there are at least a couple of situations where these
queries are not equivalent: If, for instance, a NULL value was provided
then this would appear at the top of the second query.