I'm a former Oracle user who has changed jobs and is
starting out in SQL Server.

In Oracle 8i and beyond there are extended "Analytical"
SQL functions that can only be found in Oracle
Enterprise. These include functions like ranking, inter-
row comparison, etc.

Are there similar "Analytic" SQL functions in SQL Server,
and if so, are they in all versions, or just the Enteprise.

Thanks!

Will Salomon
wsalomon@dsg.harvard.edu