Latest Date

[IanT]

I have data which I update any changes. The data contains 'Date of change'. In a query I want to show only the latest change not any previous changes. Can anyone help!!

I have tried Max([DateOfChange]) This still shows all data.

 

[raskew]

Try the Top predicate, as in:

SELECT TOP 1 Orders.OrderID, Orders.CustomerID, Orders.OrderDate
FROM Orders
ORDER BY Orders.OrderDate DESC;