Computing truncated mean

A truncated mean or a trimmed average is the average after throwing away the top and bottom n percent.

I seem to recall a built-in function in Oracle that did this fairly simply, but I can't seem to locate it in the docs. I could cook up my own in PL-SQL, but if there's something already out there I'd prefer to use it. Anybody know a simple way to do it?

Thanks.

//Walt

W2k3, Ora 9.2 if that matters... Received on Tue Feb 06 2007 - 15:40:48 CST