Get Distinct Maximum Date
Display the latest order of each customers.
SELECT A.CustomerID, OrderDate, EmployeeID, ShipperID FROM Orders AS A INNER JOIN
(SELECT CustomerID, MAX(OrderDate) AS MaxOrderDate FROM Orders GROUP BY CustomerID) AS B
ON A.CustomerID=B.CustomerID AND A.OrderDate=B.MaxOrderDate
Display the latest order of each customers.
SELECT A.CustomerID, OrderDate, EmployeeID, ShipperID FROM Orders AS A INNER JOIN
(SELECT CustomerID, MAX(OrderDate) AS MaxOrderDate FROM Orders GROUP BY CustomerID) AS B
ON A.CustomerID=B.CustomerID AND A.OrderDate=B.MaxOrderDate