median value

[Quoted] [Quoted] I need to pull the median value out of a table for a particular field.

[Quoted] The median value is the middle record. So if I had 10 records sorted in I would want the value is record 5. I can't just go get that rownum because the records are not loaded in order and Oracle does not allow the order by to be used in create table or view.

Thanks, Lisa Received on Wed Dec 11 1996 - 00:00:00 CET