Re: A VERY DIFFICULT QUERY

From: Kenneth C Stahl <BluesSax_at_Unforgettable.com>
Date: Thu, 15 Jul 1999 07:49:42 -0400
Message-ID: <378DCAD6.6003C15D@Unforgettable.com>

This is one of the reasons I left Mensa. I just couldn't see the point in intellectual challenges for the sake of intellectual challenges. Posing a problem and then saying that answers are not acceptable if they use a particular technique fall into this category.

If you want others to help solve a problem using a real world situation then there are probably many of us who are glad to help - but to ask for a solution to a problem such as this is simply an intellectual exercise and serves no real useful purpose.

nooruddin wrote:

> Hi!
>
> I want a sql query for the following result:
>
> From a table containing salaries (say emp table)
>
> I want the salary which is closest to the average of all the
> salaries
> (it seems easy at first look, but I assure you its not the case)
>
> NOTE:The query should be an sql statement and not a pl/sql script.
> good luck..
>
> bye..
Received on Thu Jul 15 1999 - 06:49:42 CDT