I'll give you a tip: It'll involve 'select top 1 ... order by'
-- edit
in retrospect, this probably should've been a comment to his post. Oh well, I can accept the downvotes. Regardless though, I think with something like this it's nicer for the OP to learn himself with tips :) MHO. Continue the downvoting at will :)
-- edit to respond to comment
select top 1
pages.id,
pages.name,
version,
contents
from
pages_contents
inner join
pages on
pages.id = pages_contents.page_id
order by
pages_contents.version desc
May look something like that. I don't know cause I can't test it, but it may also have a group by in there. Forgive me if it doesn't work as-is.