Help on whriting a SQL Script / statement

[ggarbers]

SELECT Tagname,
MAX(DateAndTime),
MAX(Value)
FROM DataLog
WHERE Value = (Select MAX(Value)
FROM DataLog As B
WHERE B.TagName = DataLog.TagName)
GROUP BY TagName
ORDER BY TagName DESC;