Re: @HELP

From: TurkBear <johng_at_mm.com>
Date: Thu, 16 Dec 1999 21:16:42 GMT
Message-ID: <3859562e.23983486@super.news-ituk.to>

Do you want the middle row ( that is 470321 / 2 ) or the middle ( median) value of the data in the rows...?

I don't believe that a median function exists for Oracle so it may be difficult...

Jonus <jonus123_at_yahoo.com> wrote:

>hi
>
>I'm trying to get to the middle values of a column of
>a group of integers. For example, in a table of 470321 rows, I'm trying
>to get the row exactly in the middle. Is there a way to get to the
>middle value in a query, without having to do a manual
>count. There doesn't seem to be a way or I can't
>find any reference to how to do this.
>
>Thanks for any help you can give me
>Jonus
>
>
>for example:
>
>cost
>----
>4555
>4556
>5666
>9456
>6676
>877
>8888
>687
>4467
>3452
>.
>.
>.
>.
>etc

-----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==---------- http://www.newsfeeds.com The Largest Usenet Servers in the World! ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==----- Received on Thu Dec 16 1999 - 15:16:42 CST