Affichage des articles dont le libellé est Query to return most recently created records. Afficher tous les articles
Affichage des articles dont le libellé est Query to return most recently created records. Afficher tous les articles

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

Labels