how to find common rows from table in sql server

Question

0.00/5 (No votes)

See more:

I am working on one database(ecommerce site). in that one table with duplicate records.I want your help to find duplicate records in a 50 column table on SQL Server.

There are '_id' column have primary key in table but i have to avoid it for find duplicate records .

Posted 16-May-13 19:15pm

Archit Patel

Updated 16-May-13 19:23pm

v3

Add a Solution

Comments

Aarti Meswania 17-May-13 1:19am

Is there any primary key in table?

[no name] 17-May-13 1:22am

yes there are '_id' column have P.K. in this table but i have to avoid it for find duplicate records .

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sant Osha · Answer 1 · 2013-05-16T19:27:00

Solution 1

select col_name,count(col_name) from tbl_name group by col_name having count(col_name) > 1

Posted 16-May-13 19:27pm

Sant Osha

Comments

[no name] 17-May-13 1:35am

it give only one column duplicate data i have to find out from 49 row exclude p.k. column.

Sant Osha 17-May-13 3:17am

49 rows or column ?

gvprabu 17-May-13 3:26am

shall u give the 49 column sample value, then only we have decide. But we can't able to write sql query for find the duplicate records with the combinations of 49 columns.