Re: This is how U can find out the 'N'th maximum value from a table by sql
From: Tom McClelland <tom.mcclelland_at_mondas.com>
Date: 20 Feb 2002 02:33:54 -0800
Message-ID: <cb748650.0202200233.6160564d_at_posting.google.com>
Date: 20 Feb 2002 02:33:54 -0800
Message-ID: <cb748650.0202200233.6160564d_at_posting.google.com>
Bricklen <bricklenREMOVETHIS_at_shaw.ca> wrote in message news:<3C726AB4.201F0E73_at_shaw.ca>...
> Why not just use an analytic function? They are more versatile, less
> performance overhead, and less coding (row_number,rank,dense_rank,etc).
>
> Tom: the RANK function IS for selecting the Top N in the list, however
> you'd like to determine them. Good in 8.1.6 and up.
>
Received on Wed Feb 20 2002 - 11:33:54 CET