select grzh, jyxh, ye
from jymx a, (select grzh xx, max(jyxh) yy from jymx group by grzh) b
where a.grzh = b.xx and a.jyxh = b.yy and a.grzh <> '0''