SELECT DEPT.NAME, COUNT(EMP.NAME)
ON DEPT.DEPT_ID = EMP.EMP_ID
WHERE EMP.SALARY > (SELECT SALARY FROM EMP WHERE EMP_ID = 13)
AND DEPT.DEPT_ID <> 42
Open in new window
IT issues often require a personalized solution. With Ask the Experts™, submit your questions to our certified professionals and receive unlimited, customized solutions that work for you.
Take hold of your future.