Re: Can I do this using SQL?

From: Dieter Noeth <>
Date: Sun, 12 Feb 2006 11:30:38 +0100
Message-ID: <dsn2pp$l8h$>

Troels Arvin wrote:

> I've written about the subjects at
> (section: "Limiting result sets").

Good comparison, but Teradata is still missing ;-)

You could add some info:
Starting with SQL Server 2005 Microsoft supports a limited subset of SQL:2003 OLAP functions, too.

Ranking functions:
RANK, DENSE_RANK, ROW_NUMBER OLAP aggregates, but a window definition is not supported, it defaults to: ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING e.g. SUM(x) OVER (PARTITION BY y)

Dieter Received on Sun Feb 12 2006 - 11:30:38 CET

Original text of this message