Migrating Aggregate Functions from Oracle to SQL Server

This table shows the equivalent Microsoft® SQL Server™ function for each Oracle function.

Function Oracle SQL Server
Average AVG AVG
Count COUNT COUNT
Maximum MAX MAX
Minimum MIN MIN
Standard deviation STDDEV N/A
Summation SUM SUM
Variance VARIANCE N/A

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.