I think you need to look at the ntile() analytic function.
Some documentation in the SQL reference guide,
more in the Data Warehousing reference guide.
--
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the questions, but the
person who can question the answers -- T. Schick Jr
One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html
____Belgium__November (EOUG event - "Troubleshooting")
____UK_______December (UKOUG conference - "CBO")
Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
____UK___November
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
"Grzegorz" <gb_at_gazeta.pl> wrote in message
news:16de1593.0310270124.659d0a0e_at_posting.google.com...
> Hello.
>
> Is there a method to get quantile from query?
> For example:
>
> select quantile( f1, 50), quantile( f2, 90) from t
> where k1 = 'f..k!!!'
> ?
>
> Thanks in advance,
> Grzegorz
Received on Tue Oct 28 2003 - 10:20:09 CST
