If your table has multiple records per employee as in
EmployeeID, EmployeeName
------------------------------------
12345, John Smith
12346, Jane Doe
12345, John Smith
12347, Bob Smith
You can group these records together, and use the aggregate function "COUNT" to get a number of rows each employee has in the table. This can be done using this script
SELECT EmployeeID, EmployeeName, COUNT(*) AS RowCount FROM TableA
GROUP BY EmployeeID, EmployeeName
ORDER BY RowCount DESC --this will sort most row count first
Since Employee, John Smith, has two records in the table, his row count will be 2, while Jane Doe and Bob Smith will only have 1.
EmployeeID, EmployeeName, RowCount
-------------------------------------
12345, John Smith, 2
12346, Jane Doe, 1
12347, Bob Smith, 1
Hope this helps
Unsolved 
