1. fauzanf New Member

   Hello My Friends,
   I want to know the SQL Syntax to find the duplicate value in one field of Table.
   Anybody can help me...?
   Thank you.
   

   fauzanf, Jan 3, 2010

   #2
2. Madhivanan Moderator

   SELECT col FROM yout_table
   GROUP BY col
   HAVING COUNT(col)>1
   

   Madhivanan, Jan 4, 2010

   #3

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in