Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: discarding first and last element from an ordered set of values

Re: discarding first and last element from an ordered set of values

From: Mladen Gogala <gogala_at_sbcglobal.net>
Date: Mon, 20 Feb 2006 18:27:20 GMT
Message-Id: <pan.2006.02.20.18.27.20.732671@sbcglobal.net>


On Mon, 20 Feb 2006 15:42:01 +0100, Maxim Demenko wrote:

> SELECT DATA FROM (
> SELECT DATA ,
> row_number() over(ORDER BY DATA) rwnum,
> COUNT(*) over() cnt
> FROM tab)
> WHERE rwnum>1 AND rwnum<>cnt
>

Your solution is better then mine. Regards.

-- 
http://www.mgogala.com
Received on Mon Feb 20 2006 - 12:27:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US