All Forums Analytics
jarmoney 1 post Joined 05/11
16 Oct 2011
SQL help - Median, 75th percentile price

I just recieved an adhoc request to get some report from teradata -

We have an Orders table that stores brand, item and price.  For every brand, for every item, we want to find out the median price, the 25th percentile price and the 75th percentile price. 

My questions are:

1. I should be knowing this but what does a 25th or 75th percentile price mean to you? What could it also mean?

2. A working query would be very very helpful


Thanks much,


Adeel Chaudhry 773 posts Joined 04/08
17 Oct 2011



There is a very nice article from our most active forum member Dnoeth on this topic. Link is as follows:




Regards, Adeel

-- If you are stuck at something .... consider it an opportunity to think anew.

You must sign in to leave a comment.