creating a view problem with revision

ANSI based way

SELECT *
FROM TableName t
WHERE NOT EXISTS (SELECT 1
FROM TableName
WHERE column2 = t.column2
AND revision > t.revision
)

---

Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://ift.tt/19nLNVq http://ift.tt/1iEAj0c