Hello again,
Let's assume class:
class Product
{
int Id,
string ProductName,
string GroupName,
decimal ProductPrice
}
I like to select all products, that has highest price within group.
Example:
Product (1,'ProductA','GroupA',7)
Product (2,'ProductB','GroupA',12)
Product (3,ProductC','GroupA',2)
Product (4,'ProductA','GroupB',78)
Product (5,'ProductB','GroupB',42)
Product (6,ProductC','GroupB',4)
Product (7,'ProductA','GroupC',13)
Product (8,'ProductB','GroupC',5)
Product (9,ProductC','GroupAC,100)
The correct result is list of Product with ids: 2,4,9
Does anyone have idea how to do this?
In sql I can use solution from first question
http://www.techonthenet.com/sql/max.php
Bartosz Pierzchlewicz
--
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en.
