Do you want to find out how to avoid duplicates in the results of a SQL SELECT query? This article will show you how. Simply use the DISTINCT clause and between the SELECT clause and the fields.

After #9114, the IT engine fails to run well with the SELECT DISTINCT SQL. It is necessary to find the cause and fix it.

We often need to select distinct records from a list or from database. In Linq, we can select distinct records from a list or collection using Distinct method. Suppose we have a list with the name ...

This blog will help you when you need to select distinct records from a datatable on basis of selected columns. Suppose we have a datatable which holds the employee records. This datatable has ...

As I mentioned Monday and in my Visual Studio 2008 review, I've been struggling with the finer points of LINQ queries. In a talkback comment to my review, "CSharper" pointed me at one solution to ...