phpsqlaggregate-functionsrdbmsrdbms-agnostic

Is MAX, MIN, SUM SQL command standard accross diffrent RDBMS


I only have MySQL installed right now but will these work fine when run in PgSQL, MS SQL, etc.?

SELECT MAX(field) as max_field FROM table
SELECT MIN(field) as max_field FROM table
SELECT SUM(field) as max_field FROM table

Solution

  • You could check for yourself, but aggregate functions are common across most, if not all, RDBMS:

    You get the idea.