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: Charles Hooper <hooperc2000_at_yahoo.com>
Date: 20 Jan 2007 04:05:00 -0800
Message-ID: <1169294700.258926.65920@38g2000cwa.googlegroups.com>

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

Original text of this message

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