Is there anything similar to Oracle Analytics in SQL Server 2008?

Question

I used Oracle Analytics for SQL. Is something like that available in SQL Server 2008 Express and Compact?

Answer 1

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.