>How to create a sql command that would retrieve a duplicate field value in a table. let say duplicate employee no. i just want to ask if this is possible so that i won't make a small program 4 that.
something like:
SELECT EmployeeNo, count(*)
FROM YourTable
GROUP BY EmployeeNo
HAVING COUNT(*) > 1
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com