Re: Can I do this using SQL?
From: Dieter Noeth <dnoeth_at_gmx.de>
Date: Fri, 10 Feb 2006 13:14:37 +0100
Message-ID: <dsi04m$lmf$1_at_online.de>
Date: Fri, 10 Feb 2006 13:14:37 +0100
Message-ID: <dsi04m$lmf$1_at_online.de>
Dieter Noeth wrote:
> ROW_NUMBER -> exactly 10 rows
> RANK -> then rows plus all the rows with the same value as the 10th.
RANK -> ten rows plus all the rows with the same value as the 10th.
> DENSE_RANK -> all the rows with the 10 highest distinct values
Received on Fri Feb 10 2006 - 13:14:37 CET