General information
Category:
Coding, syntax & commands
Title:
Need Help with SQL Statement
Can anyone tell me if the following can be done in a one line select statement. I cannot seem to get the results I require.
I have one table with the following fields: Customer, Date, Price. I am simply trying to get the last price quoted to the customer.
CustA, 01/01/01, 100
CustA, 01/01/97, 111
CustB, 02/02/96, 200
CustB, 02/02/02., 222
I want my result to be:
CustA, 01/01/97, 111
CustB, 02/02/96, 200
If I use SELECT * FROM myTable ORDER BY Date DESC GROUP BY Customer
I get ...
CustA, 01/01/01, 100
CustB, 02/02/01, 222
Again, I am looking for the last price quoted only.
Any help would be greatly appreciated.
-Isaac Roda
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only