Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL max() and corresponding fields
Message
From
14/07/1999 13:48:34
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
SQL max() and corresponding fields
Miscellaneous
Thread ID:
00241387
Message ID:
00241387
Views:
54
Is it possible to get the maximum value from a field and other fields corresponding to the same record?

i.e: Given a table with OrderNumber, CustId and total_Price, How do I get the highest total_price for every CustId and the Corresponding OrderNumber in a single query?

I´ve tried something like:
Select CustId, OrderNumber,max(total_price) from [Tablename] group by CustId

It returned the maximum value of "total_price" for every CustId, but the "OrderNumber" returned is not correct, given that in the source table the total_price for that Order_Number is not the same.

Tks
There´s a better life... Just it´s more expensive!
Cristóbal Manrique M.
Next
Reply
Map
View

Click here to load this message in the networking platform