Re: Limitting result without ROWNUM

Charles Hooper schreef:
> Frank van Bortel wrote:

>> 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...

Your toe or mine ?
What about hammer-toes?

>
> OK, now to develop the solution for a translation system. In Google
> search for:
> 79 inches in cm

Ah - it was in inches - not centimeters!
>
> One hit: 79 inches = 200.66 centimeters

Giants, I'd say, but I'm only 1.77. Meters, that is :)

>
> Oracle provides a means of requesting web page content. Write a SQL
> statement that queries Google to translate the big toe measurement to
> an equality statement; it is not permitted to simply multiply the big
> toe measurements by 2.54. That sounds like a decent request for the
> instructor who asked the students to develop a completely unscalable
> solution to a problem that could have been handled quite efficiently
> using ROWNUM.
>
> Charles Hooper
> PC Support Specialist
> K&M Machine-Fabricating, Inc.
>

And shows how to manipulate html, using pl/sql, and the capabilities of the rdbms as data retrieval system, and the use of google which is always beneficial for students.

But I'll make one statement in favor of the instructor: he was thinking outside the box. Or at least, trying to get his students, this ng, in fact the whole world to look at things differently. And that is what -in my book- is education is all about.

There's more than one way to Rome.
It's not better, it's not worse, it's just different (thanks, YFUNL/Bob)

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...