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

Hi Will,

You can find a comparison of the different SQL Server editions here:
http://www.microsoft.com/sql/techinf...skChooseEd.asp

Basically the SQL in all the versions (except CE Edition) is the same,
although some functionality that you can find in Oracle won't be in SQL
Server and the other way around.
If you are looking for analytical functions you should have a look at
Analysis Services, Microsoft's OLAP tool that comes free with SQL Server.

--
Jacco Schalkwijk MCDBA, MCSD, MCSE
Database Administrator
Eurostop Ltd.


"Will Salomon" <wsalomon@dsg.harvard.edu> wrote in message
news:02a701c35b93$9ddf40c0$a501280a@phx.gbl...
> 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