Re: Can I do this using SQL?

From: Dieter Noeth <dnoeth_at_gmx.de>
Date: Sun, 12 Feb 2006 11:30:38 +0100
Message-ID: <dsn2pp$l8h$1@online.de>

Troels Arvin wrote:

> I've written about the subjects at http://troels.arvin.dk/db/rdbms/
> (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 - 04:30:38 CST