Home » SQL & PL/SQL » SQL & PL/SQL » Median
Median [message #2452] Wed, 17 July 2002 06:14 Go to next message
Mike Nibeck
Messages: 49
Registered: May 2002
Member
Anyone know of a good algorithm to determine the MEDIAN value of a column? Is there a built-in function?

Report message to a moderator

Re: Median [message #2455 is a reply to message #2452] Wed, 17 July 2002 11:29 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
There is no built-in support for calculating a median until 9i (using the percentile_disc analytical function).

Report message to a moderator

Previous Topic: Re: Find record, that causes DUP_VAL_ON_INDEX
Next Topic: Table Access
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 15:52:32 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.