Monday, March 10, 2008

There is an employee table having dep_id field and another department master table.List aa dept not having any employee

Select dept_id from department where dept_id not in(select dept_id from employee)

No comments: