Re: Creating an aggregate operator
From: Paul Q <paulq_at_home.com>
Date: Sat, 11 Nov 2000 23:25:04 GMT
Message-ID: <kzkP5.79692$78.25038515_at_news3.rdc1.on.home.com>
Date: Sat, 11 Nov 2000 23:25:04 GMT
Message-ID: <kzkP5.79692$78.25038515_at_news3.rdc1.on.home.com>
select min(field) from your_table
where field != (select min(field) from your_table)
"Brett O'Neill" <bretto_at_swbell.net> wrote in message
news:T82P5.834$_w6.105605_at_nnrp1.sbc.net...
> Does anyone know how to add a new aggregate operator, ie. "SECOND
SMALLEST,"
> which would be similar to MIN?
>
> Any help greatly appreciated!
>
>
Received on Sun Nov 12 2000 - 00:25:04 CET