select * from jcbb a where a.ccrq is null  and a.jcrq =(select max(jcrq) from jcbb b where a.kh = b.kh ) 

select * from jcbb
where not exists(select 1 from jcbb j where kh=jcbb.kh and jcrq>jcbb.jcrq)

select jcbb.kh,jcbb.xm,jcbb.cph,jcbb.klx,jcbb.jcrq,jcbb.sfgq,jcbb.images from jcbb,
(select B.kh,jcrq = min(B.jcrq) FROM jcbb B group by B.kh)A
where jcbb.kh = A.kh AND jcbb.jcrq = A.jcrq    

select * from jcbb a
where not exists(select 1 from jcbb b
where a.kh=b.kh and a.jcrq<b.jcrq)

select * from jcbb a
where a.jcrq in (select max(b.jcrq) from jcbb b where a.kh=b.kh)

select * from jcbb a
where a.jcrq  in (select top 1 b.jcrq from jcbb b where a.kh=b.kh
order by b.jcrq desc)