Re: Limitting result without ROWNUM

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

Is the length of one's big toe not a standard? It would assure equality in measurement for infants, senior citizens, and midgets. :-)

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

One hit: 79 inches = 200.66 centimeters

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. Received on Sat Jan 20 2007 - 06:05:00 CST