Pleasure writing back in this forum after a pretty long time.
At the outset, I'd like to surrender that I tried to search through all the post, but somehow did not get any relevant posts,
but if there are any, please let me know of it.
I'm trying to retrieve records from a table called EMPLOYEE where employee salary is greater than or equal to the
average sal of the concerned department
the table schema is as follows:
EMPID(integer)
EMPNAME(string)
SAL(integer)
DEPTCD(integer)
The way I did it is:
Code: Select all
Oracle Connector(to fetch DEPTCD, AVG(SAL) as AVG_SAL GROUP BY DEPTCD)
|
|
|
|
Oracle Connector----------Join-----------Filter-----------------Output Data Set
(to read from (on DEPTCD) (where SAL>=AVG_SAL)
EMPLOYEE table)
Is there a better way of doing this?
Thanks & Regards,
Kumarjit.