Information générale
Catégorie:
Codage, syntaxe et commandes
Then, I'm not sure I understand your question.
> I want all of the newest records and ignore older matching records
Please define "newest records" (since a given date or since the last query?).
And what do you mean by "matching records"? Are two or more tables involved?
>Thanks for the idea, but not quite what I had in mind. I want all of the newest records and ignore older matching records (matching on MailingListId and ListSelectId)
>
>>SELECT TOP 10 MailingListId, ListSelectId, ;
>> StateCountAsOF, ;
>> StateCountId ;
>> FROM StateCount ;
>> INTO CURSOR zStateCount;
>> ORDER BY StateCountAsOf DESC
>>
>>HTH
>>
>>>I'm trying to use the following SELECT to get me the most current record(s) from my table based on the DateTime field StateCountAsOf.
>>>The field StateCountId is the Key field for each record.
>>>
>>>SELECT MailingListId, ListSelectId, ;
>>> MAX(StateCountAsOF) AS StateCountAsOF, ;
>>> StateCountId ;
>>> FROM StateCount ;
>>> GROUP BY MailingListId, ListSelectId ;
>>> INTO CURSOR zStateCount
>>>
>>>When I run my SELECT I get the most current date but the field ListSelectId (which is a key into another table is for another record). I tried GROUP BY MAX(StateCountAsOf) and HAVING BY MAX(StateCountAsOf) but get syntax errors. I can't use StateCountId in my GROUP BY because I then get all records (since it is the key field).
Précédent
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