Double ~

[tweetysamm]

Everyone,

can i know how to write a SQL query that can draw out how many duplicate data in one field?

 

[maxmangion]

you can run a Find Duplicates Query Wizard which does what you are looking for.