Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement