join query

[User 13887573]

how to find one employee belongs to max dept

[Lost User]

Please think about what your question says. We have no idea what your table structures are, or what fields are associated with an employee record.

[Victor Nijegorodov]

What is "employee"? What is "dept"? What is the relationship between them?

[Mycroft Holmes]

With as little information as you have supplied this may give you some ideas.

select *
from Employee
where DepartmentID =(
select top 1 DepartmentID from(
select DepartmentID , count(*) C
from Employee
group by DepartmentID) x order by C desc)

Never underestimate the power of human stupidity RAH