Query to return most recently created records

mardi 3 mars 2015

I need this query to return the most recently created records in a composite key field, and only the most recent ones.



there is a screenshot of the composite key field attached



I want to get the records with the highest InvoiceID, there can be multiple records with the same InvoiceID and I want to get all of them.



Using the screenshot as an example I need to query to return the last two records as they both have the Same, highest InvoiceID.




Attached Images





File Type: jpg screenshot.JPG (41.5 KB)



Query to return most recently created records

0 commentaires:

Enregistrer un commentaire

Labels