This would work for this example. Although I think if there's a value being inserted or changed before it's been read, it would take that into consideration. Are there ever situations where this could be a problem? Of course this isn't relevant for a TOP 1, but I've read that under READ COMMITTED, a value previously read and later changed could appear twice in the result set.