select max(fieldy) from mytable where fieldx = 'xyz'

I think that will do it....