I want to select the last note from notes with the following query:
SELECT cn.Note, MAX(cn.Date) FROM CarsNote cn WHERE CustomerID = '80' AND cn.Type = 'INFO' GROUP BY Note
When I execute this query i get four results but i want only the last note.
When i do
SELECT TOP 1 I don't get the lastest note .
What is missing here?