Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Limitting result without ROWNUM
Charles Hooper schreef:
> First experiment:
> SELECT
> MIN(HEIGHT) OVER (ORDER BY HEIGHT DESC) MIN_HEIGHT
> FROM
> T1;
>
> MIN_HEIGHT
> ----------
> 79
> 76
> 73.5
> 73
> 72.5
> 72
> 65.5
> 65
> 62.5
> 62
> 60.5
> 60
> 59
> 50
> 48.5
> 48
>
> Interesting, useful?
>
What's this - all midgets?
Could the world at least adhere to the use of standards?
Meter would be a fine example, and in case of body length, the
1/100th part of that, the centimeter: cm.
-- Regards, Frank van Bortel Top-posting is one way to shut me up...Received on Sat Jan 20 2007 - 04:40:53 CST
![]() |
![]() |