SELECT DISTINCT company, last_name, first_name FROM Sales; You can still use DISTINCT when narrowing and sorting your results, as with any SELECT statement.

In a talkback comment to my review, "CSharper" pointed me at one solution to finding the LINQ equivalent of a SQL "SELECT DISTINCT" query: tack on a LINQ .Distinct () method call to the query ...

Sql query help, selecting newest distinct record Hoostine May 12, 2008 Jump to latest Follow Reply ...

I know this one is gonna be pretty simple... I'm just not sure of the exact syntax. I know it has something to do with "distinct" but I'm not sure the context to use here:Here's my query: select ...