Versions Compared

Old Version 1

changes.mady.by.user DATABASICS, Inc.

Saved on

compared with

New Version Current

changes.mady.by.user Anthony Vallelonga

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Returns the number of rows matching the query criteria

SELECT COUNT(*) FROM EMPLOYEEEmployee

AVG

Returns the average of rows matching the query criteria

SELECT locationCode, AVG(maxHours) FROM EMPLOYEE Employee GROUP By locationCode

MIN

Returns the minimum number of rows matching the query criteria

SELECT MIN(maxHours) FROM EMPLOYEEEmployee

MAX

Returns the maximum number of rows matching the query criteria

SELECT MAX(maxHours) FROM EMPLOYEEEmployee

SUM

Returns the total sum of rows matching the query criteria

SELECT SUM(maxHours) FROM EMPLOYEEEmployee