大家看一下这个问题怎么解决啊!
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是日期型字段,我想选一个最靠后的日期来和它对应数据进行处理,
但选出的是多条记录,大家看一下怎么解决阿??
谢谢