select xh,kcm,zxjxjhh,max(kccj) kccj from 表 group by kccj
以下是引用wp231957在2013-12-31 10:34:39的发言：
select xh,kcm,zxjxjhh,max(kccj) as cj_new from table_name group by kcm
加SYS(3099)试试
select xh,kcm,zxjxjhh,max(kccj) as cj_new from table_name group by kcm
