$$$$$A$$$2'A---sss-A###sel select max(cid),cids from hch01 where cco = 'A'-->