Home » SQL & PL/SQL » SQL & PL/SQL » Statistical Computations (10 g)
Statistical Computations [message #365092] Wed, 10 December 2008 23:24 Go to next message
maheshmhs
Messages: 93
Registered: October 2008
Location: Nepal
Member
Hi,

From a table i need to calculate max, mean, min, 5th percentile, 95 th percentile, standard deviation with group by function. I have come to know there are analytical functions too. But i don't think i need to use that. But i need a faster result.
What could be the best option for calculating it.

thank you
Re: Statistical Computations [message #365096 is a reply to message #365092] Wed, 10 December 2008 23:32 Go to previous messageGo to next message
wmgonzalbo
Messages: 98
Registered: November 2008
Member
Hi, what do you mean by 'faster result' that dissuades you not to use those pre defined functions? Are those analytical functions slowing your process?

[Updated on: Wed, 10 December 2008 23:34]

Report message to a moderator

Re: Statistical Computations [message #365098 is a reply to message #365092] Wed, 10 December 2008 23:39 Go to previous messageGo to next message
flyboy
Messages: 1832
Registered: November 2006
Senior Member
Quote:
But i need a faster result.

Faster than what? Printing it and computing manually?
Quote:
I have come to know there are analytical functions too.

Using GROUP BY leads to usage of aggregate form of those functions.
Quote:
But i don't think i need to use that.

As you do not require SUM, I suppose you already managed it without using aggregate SUM function. Proceed the same way with another functions.
Re: Statistical Computations [message #365100 is a reply to message #365096] Wed, 10 December 2008 23:40 Go to previous messageGo to next message
maheshmhs
Messages: 93
Registered: October 2008
Location: Nepal
Member
i mean it shouldn't be too slow.

Besides, if there are already functions that gives the value which is lets say 95th percentile, then i don't need to write such long queries. I am not sure if there are such functions like percentile or something.

[Updated on: Wed, 10 December 2008 23:49]

Report message to a moderator

Re: Statistical Computations [message #365105 is a reply to message #365092] Thu, 11 December 2008 00:25 Go to previous messageGo to next message
wmgonzalbo
Messages: 98
Registered: November 2008
Member
If you are asking if such functions that does statistical computations like MAX, MIN, PERCENTILE, MEDIAN etc. exists, yes they do exist, try searching for them.. And they are fast enough and convenient to use, well for me..

Regards,
Wilbert
Re: Statistical Computations [message #365107 is a reply to message #365092] Thu, 11 December 2008 00:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database SQL Reference
Chapter 5 Functions
Section SQL Functions

Regards
Michel
Re: Statistical Computations [message #365119 is a reply to message #365107] Thu, 11 December 2008 00:51 Go to previous message
maheshmhs
Messages: 93
Registered: October 2008
Location: Nepal
Member
thank you EVERYONE.

I FOUND percentile_disc WOULD SOLVE MY PROBLEM
Previous Topic: Parse SQL: How to extract column names, table names from a SQL query
Next Topic: Execution of multiple statements under WHEN NOT MATCHED clause in MERGE
Goto Forum:
  


Current Time: Fri Dec 09 23:12:46 CST 2016

Total time taken to generate the page: 0.24013 seconds