I have a list that has values as displayed below
Using Linq how can i get the minimum from COL1 and maximum from COL2 for the selected id.
id COL1 COL2
=====================
221 2 14
221 4 56
221 24 16
221 1 34
222 20 14
222 1 12
222 5 34
Based on the below list it should display id 221 1 56
and 222 1 34
help me out