quick question I have no problem getting the averages using this query:
<CFQUERY datasource="#DSN#" name="average">
SELECT AVG(passengers_enplaned_domestic) as
avg_passengers_enplaned_domestic,AVG(passengers_enplaned_international) as
avg_passengers_enplaned_international,AVG(passengers_enplaned_transfer) as
avg_passengers_enplaned_transfer,
FROM rates_and_charges2, rates_and_charges1, airport_info
where rates_and_charges2.member_number = airport_info.member_number
and rates_and_charges1.member_number = airport_info.member_number
</CFQUERY>
I would like to do something similar to get the MEDIAN... now SQL claims to
have a MEDIAN function yet when i use
it i get an error saying that function doesnt exist. Has anyone ever done a
median query?? any help would be appreciated.
Kelly
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
