我试过这样SELECT DISTINCT AMCRINO as ao,am,ad from (select DISTINCT AMCD as am,ad,AMCRINO from ( SELECT DISTINCT AMCRIORD as ad ,AMCRINO,AMCD from T004ApldMdlCri));但不行 请帮助
select * from tablename a where AMCD =(select max(AMCD) from table1 where AMCRINO=a.AMCRINO and AMCRIORD=(select max(AMCRIORD) from table1 where AMCRINO=a.AMCRINO) )
select distinct * from (select a, b, c from load_instruction)easy!
SELECT DISTINCT AMCRIORD as ad ,AMCRINO,AMCD from T004ApldMdlCri));但不行 请帮助
where AMCD =(select max(AMCD) from table1 where AMCRINO=a.AMCRINO and AMCRIORD=(select max(AMCRIORD) from table1 where AMCRINO=a.AMCRINO) )