Top "Distinct" questions

The DISTINCT keyword is used to remove duplicate values from a result of a SQL or SPARQL query.

Select distinct by two properties in a list

I have a list<message> that contains properties of type Guid and DateTime (as well as other properties). …

c# list distinct linq-to-objects
LINQ to DataSet, distinct by multiple columns

Just wanted to check if there is way to do distinct by multiple columns. Thanks in advance!!! BTW, I found …

linq distinct linq-to-dataset
Use a delegate for the equality comparer for LINQ's Distinct()

I have a LINQ Distinct() statement that uses my own custom comparer, like this: class MyComparer<T> : IEqualityComparer&…

c# linq distinct
LINQ Select Distinct Count in Lambda form

Given a linq expression of an object collection 'items' such as this: var total = (from item in items select item.…

c# linq select lambda distinct
SAS distinct in proc sql vs proc sort nodupkey

I have following dataset: data work.dataset; input a b c; datalines; 27 93 71 27 93 72 46 68 75 55 55 33 46 68 68 34 34 32 45 67 88 56 75 22 34 34 32 ; run; I want to select all distinct records …

sql sorting sas distinct proc
How to use Distinct function in influxDB

I am using influx DB and issuing command, SELECT * FROM interface Below is the out put- interface time element path …

distinct influxdb distinct-values
Distinct values with pluck

I'm trying to retrieve data from database and bind them to a html select tag, and to bind them i …

laravel distinct laravelcollective pluck
Using distinct on a column and doing order by on another column gives an error

I have a table: abc_test with columns n_num, k_str. This query doesnt work: select distinct(n_num) …

sql oracle sql-order-by distinct oracle9i
CakePHP 2.1 - How to properly use DISTINCT in find()

I have a question which is driving me crazy and I have to admit I am not that experienced in …

cakephp find cakephp-2.0 distinct extract
Entity Framework returning distinct records issue

I have a PC Enity which have some Properties , I would like to return a list of distinct Object (PC …

c# asp.net entity-framework distinct complextype