I Have a table in which there is a chance of duplicate rows. Can you please tell me how to eliminate the dup;licate records?

I Have a table in which there is a chance of duplicate rows. Can you please tell me how to eliminate the dup;licate records?

Use primary key If column is like Id or no..Alternate way is you can apply unique constraint on column.. hope u hv cleared ur doubts 


By:chaitanya
Date:0000-00-00 00:00:00

Use primary key If column is like Id or no..Alternate way is you can apply unique constraint on column.. hope u hv cleared ur doubts 


By:Bojja Ravi Kumar
Date:0000-00-00 00:00:00

Post Your Answers


User Email:

User Name:
Answers:

Related SQL Subjective Links

SQL Subjective interview questions and answers for experienced and fresher