Reading Duplicate Values from the Table

Indrajeet Sutar

Rate me:

5.00/5 (1 vote)

7 Apr 2010CPOL

8.7K

Hi, on many occasions we want to search some repeated values in one or more columns. It is quite simple to do this...select ColumnName, count(ColumnName) as NumberOfTimesfrom TableNameGroup By ColumnNamehaving (count(ColumnName) > 1)At the same time, there is also a requirement...

Alternatives

Members may post updates or alternatives to this current article in order to show different approaches or add new features.

No alternatives have been posted.

License

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

Written By

Indrajeet Sutar

Software Developer (Junior) Excel Informatics, Pune

India

Am Indrajeet T. Sutar. I am a web developer. I am working on .net technology. I have completed my Masters in Computers and Management (people call it as MCA, MBA etc.) Apart from programming i do photography (not regularly though), traveling and reading books.

Reading Duplicate Values from the Table

Alternatives

License

Comments and Discussions