Mark This Response as Answer -- Chandu http://www.dotnetfunda.com/images/dnfmvp.gif
SELECT EMPLOYEE_ID , COUNT(EMPLOYEE_ID ) AS NUMBER_OF_OCCURANCESFROM EMPLOYEES GROUP BY EMPLOYEEHAVING COUNT(DEPARTMENT_ID) > 1
Thank you for posting at Dotnetfunda [Administrator]
Login to post response