I would appreciate if someone could tell me how to use SQL Query Builder to only display the most recent transaction in an Inventory Transaction Table
PartTran table I have here is almost 1 million records across 3 years and I only want to extract the most recent transaction date
The single most recent, and not per part?
SELECT TOP (1) *
FROM dbo.[Inventory Transaction]
ORDER BY transaction_date DESC