Is there anything similar to Oracle Analytics in SQL Server 2008?
I use开发者_如何学编程d Oracle Analytics for SQL. Is something like that available in SQL Server 2008 Express and Compact?
SQL Server has Analysis Services, but this isn't available in the free versions: Express and Compact.
see:
SQL Server 2008: Editions
Compare SQL Server 2008 Edition Features
SQL Server does have these: Ranking Functions (Transact-SQL) and Aggregate Functions (Transact-SQL) which may bee what your are after.
精彩评论