Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Duplicate records
- Thread starter smithcza
- Start date
something like this would identify them. If you want to delete them, there needs to be a way to tell which rows you want to keep.
Hope this helps,
Alex
Ignorance of certain subjects is a great part of wisdom
Code:
select [UniqueColumn]
, count([UniqueColumn])
from YourTable
group by [UniqueColumn]
having count([UniqueColumn]) > 1Hope this helps,
Alex
Ignorance of certain subjects is a great part of wisdom
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question