creating a view problem with revision

Here's another option for the view's query (depending on the exact specs), using Saravana's DDL:

SELECT col1, col2, col3 FROM temp12 WHERE col3 = (SELECT MAX(col3) FROM temp12)

---

Tibor Karaszi, SQL Server MVP | web | blog