mysql - Which is the least expensive aggregate function in the absence of ANY()

Question

I usally use MAX() or MIN() if a DBMS hasn't an ANY() aggregate function.

Is there something less expensive in mySQL and MS-SQL?

Answer 1

There is no ANY aggregate in ANSI SQL-92

There is the ANY qualifier to match SOME and ALL

• TSQL - SOME | ANY why are they same with different names? (SO)
• ALL, ANY, and SOME: The Three Stooges (SQL Server Pedia)

MIN and MAX are proper aggregates... completely unrelated and shouldn't be compared

Edit:

Only MySQL has this ambiguity of an "ANY" aggregate: SQL Server, Sybase, Oracle, PostGres do not. See Do all columns in a SELECT list have to appear in a GROUP BY clause