select b.* from
(
select zh,max(xh) as hz
from tb
group by zh
) a
left join tb b on a.zh=b.zh and a.xh=b.xh


下午想试sql2005的递归查询，找了半天没找到CTE的例子。。。