大家看一下这个问题怎么解决啊！

[wang_h_t_]

Select MAX(CHEXIAO_DATE),CHEXIAO_TYPE,GRANT_UNIT,
LICENSE_NUM from W_CHEXIAO where license_num='132801710913143' and SubStr(GRANT_UNIT,1,4)='1310' group by grant_unit,license_num,chexiao_type
/

CHEXIAO_DATE是日期型字段，我想选一个最靠后的日期来和它对应数据进行处理，
但选出的是多条记录，大家看一下怎么解决阿？？

谢谢

[jiezhi]

那说明即使CHEXIAO_DATE最近的也有重复数据，你可以再加限定条件或者使用rowid,rownum 什么的取头条记录。

[wang_h_t_]

怎么能取出chexiao_date最近的一条啊？

[gladness]

Select CHEXIAO_DATE,CHEXIAO_TYPE,GRANT_UNIT,LICENSE_NUM
from W_CHEXIAO a
where license_num='132801710913143' and SubStr(GRANT_UNIT,1,4)='1310'
and CHEXIAO_DATE =
(select max(CHEXIAO_DATE)
from W_CHEXIAO b
where a.GRANT_UNIT =b.GRANT_UNIT
and a.CHEXIAO_TYPE = b.CHEXIAO_TYPE
and a.LICENSE_NUM = b.LICENSE_NUM
and license_num='132801710913143' and SubStr(GRANT_UNIT,1,4)='1310')
;

[gladness]

Select CHEXIAO_DATE,CHEXIAO_TYPE,GRANT_UNIT,LICENSE_NUM
from W_CHEXIAO a
where license_num='132801710913143' and SubStr(GRANT_UNIT,1,4)='1310'
and CHEXIAO_DATE =
(select max(CHEXIAO_DATE)
from W_CHEXIAO b
where a.LICENSE_NUM = b.LICENSE_NUM
)
;

[smallfishjun]

应该是MAX有问题吧，条件好象不对，仔细检查一下，呵呵