It should be something like that:
SELECT A.RevNo, A.RevContent, A.PIC, A.Created
FROM YourTable A INNER JOIN (
SELECT RevNo, MAX(Created) AS Created
FROM YourTable
GROUP BY RevNo) AS B ON A.RevNo = B.RevNo AND A.Created = B.Created
For further details, please see:
Visual Representation of SQL Joins[
^]