SQL-Server

To find duplicate rows in table

Gaushick

Rate me:

Please Sign up or sign in to vote.

4.91/5 (4 votes)

31 Jan 2012CPOL 46.3K   6   1

To find duplicate rows in table

SQL

--To find duplicate rows in table

select colname, count(colname) from TableName
Group by colname Having (count(colname) > 1)

License

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

Written By

Gaushick

Software Developer

 India

.Net Programmer

Comments and Discussions

First Prev Next

If colname allows NULL value then use count(*) instead of co... BoBsEd2-Feb-12 1:47 BoBsEd 2-Feb-12 1:47  If colname allows NULL value then use count(*) instead of count(colname) this will diplay duplicate row with NULL value

Last Visit: 31-Dec-99 18:00     Last Update: 26-Apr-24 3:45 Refresh 1

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.