How do I remove duplicate rows and enforce case?

by Bryan Oliver

Q: How do I remove duplicate rows in database how to access small anil not capt ANIL from database?

Bryan Oliver says: There are some really great resources available online that I want to point out that can help you here. Take a look at this code for removing duplicate data on SQL Server Performance.

As for you case sensitive query take a look at this blog by Vyas Kondreddi that should answer your question (great resource by the way).

Tags:



Related Posts

  1. Using Partitioning Functions to Find Duplicate Rows Did you know that you can use the OVER clause,...
  2. SQL Server – How to get the whole group of duplicate rows We all know how to find only duplicated rows in...
  3. SQL SERVER – Query Optimization – Remove Bookmark Lookup – Remove RID Lookup – Remove Key Lookup – Part 2 This article is follow up of my previous article SQL...
  4. SQL SERVER – Query Optimization – Remove Bookmark Lookup – Remove RID Lookup – Remove Key Lookup – Part 2 This article is follow up of my previous article SQL...
  5. Philosophy and Query to Find Duplicate Records I was inspired today to pass on my method...

About This Post

  • Digg
  • del.icio.us
  • DZone
  • DotNetKicks
  • Google Bookmarks
  • Ping.fm
  • Reddit
  • StumbleUpon
  • TwitThis
Share this post with friends
Will MDX Go Mainstream?
What is a magic table and what does it do?

Leave a Reply