sql 查询语句问题！

[mugluo]

djh(单据号、字符型) ypdm(代码) mc(名称) dj(单价)
000362 215296 双黄莲胶囊 4.9
000565 215296 双黄莲胶囊 6
000607 215296 双黄莲胶囊 6

000502 21530 呋喃旦啶片 0.93
000568 21530 呋喃旦啶片 0.93
000841 21530 呋喃旦啶片 0.93
0001097 21530 呋喃旦啶片 0.93

请问高手，如何编写SQL语句才能使结果显示为：
000607 215296 双黄莲胶囊 6
0001097 21530 呋喃旦啶片 0.93
当代码相同，显示单据号最大的纪录。

thank you very much for your help.

[yelook]

select a.* from table a inner join
(
select max(cast(djh as int)) as djh,ypdm from table group by ypdm
) b on cast(a.djh as int)=cast(b.djh as int) and a.ypdm=b.ypdm

[CrazyFor]

select * from 表 as AA where not exists(select 1 from 表 as BB where aa.ypdm=bb.ypdm and cast(aa.djh as int) <cast(bb.djh as int))

[meteorlg]

select * from table a where djh=(select max(djh) from table b where a.ypdm=b.ypdm)

[hdslah]

select * from table a inner join (select ypdm,max(djh) djh from table group by ypdm) b on a.djh=b.djh)

[maoyesky]

select * from yourtable where cast(djh as int) in ( max(cast(djh as int)) from yourtable group by ypdm)

[txlicenhe]

Select * from 表 a where djh = (select max(djh) from 表 where ypdm = a.ypdm)

[playyuer]

典型的相关子查询

[hbwhwanghua]

select max(djh),ypdm,mc from table group by ypdm,mc

[pengdali]

select * from 表 tem where djh=(select max(djh) from 表 where ypdm=tem.ypdm)

[Dennis618]

select a.djh,a.ypdm,mc from 表 a right join (select max(djh) as djh,ypdm from 表 group by ypdm) b on a.djh=b.djh and a.ypdm=b.ypdm

[gmlxf]

select * from 表 where djh in (select max(djh) from 表 group by ypdm)