I think there is no case that Select max(rowid) from <Tablename>; would give more than one single record unless and untill you use a group by clause.

These group functions works on the group of...