SQL Query

[shrini]

Find DeptNo in which Maximum number of Employees are working from Employee table having EmpNo and DeptNo as fields.

[Cakkie]

This will give you one record with one field, containing the DeptNo that has the most employees in it

SELECT TOP 1 DeptNo
FROM Employees
GROUP BY DeptNo
ORDER BY Count(DeptNo) DESC





Tom Cannaerts
[email protected]

Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the universe trying to produce bigger and better idiots. So far, the universe is winning -- Rich Cook