Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: discarding first and last element from an ordered set of values
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.comReceived on Mon Feb 20 2006 - 12:27:20 CST