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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Limitting result without ROWNUM

Re: Limitting result without ROWNUM

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sat, 20 Jan 2007 11:40:53 +0100
Message-ID: <eosrji$t0m$1@news6.zwoll1.ov.home.nl>


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

Original text of this message

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