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_at_online.de>
Date: Sun, 12 Feb 2006 11:30:38 +0100
Message-ID: <dsn2pp$l8h$1_at_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 - 11:30:38 CET