Posted by uspensky on 02/24/06 19:09

I have a table (cars) with 3 fields:

VIN, Class, sell_price
101, sports, 10000
102, sports, 11000
103, luxury, 9000
104, sports, 11000
105, sports, 11000
106, luxury, 5000
107, sports, 11000
108, sports, 11000
109, luxury, 9000

i need to write a query that WITHOUT USING A FUNCTION will return the
median selling price for each class of car. result should look like:

Class, Med_Price
luxury, 9000
sports, 11000

thanks to all u SQLers

• Next in forum: log/log10 functions truncate my resultset
• Prev in forum: Re: long SQL lines for osql
• Thread view: median query without using function

[Reply to this message]