Answers for "linq distinct"

3

C# .NET Core linq Distinct

var distinctUsers = allUsers
    .GroupBy(x => x.UserId)
    .Select(x => x.First())
    .ToList();
Posted by: Guest on June-30-2020
5

MySQL DISTINCT

When querying data from a table, you may get duplicate rows. In order to remove these duplicate rows, you use the DISTINCT clause in the SELECT statement.

Here is the syntax of the DISTINCT clause:

SELECT DISTINCT
    select_list
FROM
    table_name;
Posted by: Guest on October-19-2020
0

c# distinct comparer multiple properties

List<Person> distinctPeople = allPeople
  .GroupBy(p => new {p.PersonId, p.FavoriteColor} )
  .Select(g => g.First())
  .ToList();
Posted by: Guest on April-19-2020
1

select distinct

SELECT DISTINCT ma_colonne
FROM nom_du_tableau
Posted by: Guest on March-03-2020
0

how to use distinct in linq query in c#

var distValues = objList.Select(o=>o.typeId).Distinct().ToList();
Posted by: Guest on February-04-2021
0

linq distinct

var uniquePeople = from p in people
                   group p by new {p.ID} //or group by new {p.ID, p.Name, p.Whatever}
                   into mygroup
                   select mygroup.FirstOrDefault();
Posted by: Guest on January-11-2021

Browse Popular Code Answers by Language