@HELP

From: Jonus <jonus123_at_yahoo.com>
Date: Thu, 16 Dec 1999 19:05:19 GMT
Message-ID: <83bd5a$c1q$1@nnrp1.deja.com>

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

--
Someone pass a cork to plug the hole in my head

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Dec 16 1999 - 13:05:19 CST