DISTINCT keyword

To retrieve only unique data entries a DISTINCT keyword can be used.

SQL Examples

SELECT DISTINCT LastName FROM Dynamic WHERE LastName LIKE 'Pe%'

Returns objects with unique LastName where name starts with “Pe”.

With TOP

SELECT DISTINCT TOP 2 LastName FROM Dynamic WHERE LastName LIKE 'Pe%'

With SKIP and TOP

SELECT DISTINCT SKIP 2 TOP 4 LastName FROM Dynamic WHERE LastName LIKE 'Pe%'

Database supports queries on the fields different from DISTINCT filtering field

SELECT DISTINCT SKIP 2 LastName FROM Dynamic WHERE Age > 30

LINQ Example

from Dynamic d in db where ((string)d["LastName"]).StartsWith("Pe") select d).Distinct("LastName")

Returns objects with unique LastName where name starts with “Pe”.