Row_number over (Partition by xxx) in Linq?

by

Try this one liner:

var o = beatles
    .OrderBy( x => x.id )
    .GroupBy( x => x.inst )
    .Select( group => new { Group = group, Count = group.Count() } )
    .SelectMany( groupWithCount =>
        groupWithCount.Group.Select( b => b)
        .Zip(
            Enumerable.Range( 1, groupWithCount.Count ),
            ( j, i ) => new { j.inst, j.name, RowNumber = i }
        )
    );

foreach (var i in o)
{
    Console.WriteLine( "{0} {1} {2}", i.inst, i.name, i.RowNumber );
}

Output:

Guitar John 1
Guitar George 2
Guitar Paul 3
drums Ringo 1
drums Pete 2

More Related Contents:

  1. How to flatten tree via LINQ?
  2. How to have nested query with LINQ
  3. Convert DateTime to Date string “dd/mm/yyyy”
  4. LEFT OUTER JOIN in LINQ
  5. Check whether an array is a subset of another
  6. Is there a good LINQ way to do a cartesian product?
  7. How do I concatenate two arrays in C#?
  8. Create a list from two object lists with linq
  9. How can I conditionally apply a Linq operator?
  10. LINQ to SQL – Left Outer Join with multiple join conditions
  11. Working example of CreateJobObject/SetInformationJobObject pinvoke in .net?
  12. Query an XDocument for elements by name at any depth
  13. A specified Include path is not valid. The EntityType does not declare a navigation property with the name *
  14. LINQ, Where() vs FindAll()
  15. Swap two items in List
  16. How do I get the index of the highest value in an array using LINQ?
  17. Exception using CopyToDataTable with “new {..}” LINQ query
  18. How to group by on 2 child entities and get total of both this child entities?
  19. Working with C# Anonymous Types
  20. Custom Method in LINQ to SQL query
  21. What does this C# code with an “arrow” (=>, an equal sign and greater than sign) mean and how is it called?
  22. Using Linq Except not Working as I Thought
  23. What is the purpose of AsQueryable()?
  24. Calling a SQL User-defined function in a LINQ query
  25. Why is the binary output not equal when compiling again?
  26. How to search Hierarchical Data with Linq
  27. AutoMapper for Func’s between selector types
  28. Convert / Cast IEnumerable to IEnumerable
  29. Where can I find the System.Linq.Dynamic dll?
  30. Linq – Top value from each group

Leave a Comment