A VERY DIFFICULT QUERY
From: nooruddin <nooruddin76_at_telebot.net>
Date: Thu, 15 Jul 1999 09:27:11 +0530
Message-ID: <7mkqm0$ag9$1_at_news.vsnl.net.in>
Hi!
Date: Thu, 15 Jul 1999 09:27:11 +0530
Message-ID: <7mkqm0$ag9$1_at_news.vsnl.net.in>
Hi!
[Quoted] 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 - 05:57:11 CEST