Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Is it possible to have a max function in SQL that exlcudes outliners(values 20x average)
we need to get max of a value for an account over a time period, but we want to exclude any values that are 20x greater or less than average for that account over the period
any ideas? Received on Wed Jul 19 2000 - 00:00:00 CDT