employee who work in different departments

Hi Sai,

Please find query for your requrement.

select * from Emp where EmployeeId in (

select EmployeeId from Employee_Dept group by EmployeeId having count(EmployeeId)>1)

If it helps you then please mark the answer.

0

Hi Sai,

Use below query it will work.

select * from emp where eid in( select eid from emp group by eid having count(eid)>1 )

+1

select t.* FROM (select sum(1) as nSum, deptid GROUP BY deptid) t WHERE t.nSum > 1;

+1

Okay for that you need count of group for check single record then get only greater than that

WITH CTE AS (

SELECT COUNT(eid) as counteid, deptid

FROM tbl_dept

GROUP BY deptid

)

select * from CTE where counteid>1

0

Hi Jenith,

If we have have lakhs of single eid then your query does not work.

-1

Hi Sai,

Please try below hope this will help

select * from tbl_dept tbl1 where 1 < (select count(*) from tbl_dept where tbl1.uid = uid)

+1

select * from employeedepartment where eid not in (2)

-1