什么意思?
是不是这样可以符合要求?
select distinct AMCRINO, AMCD, AMCRIORD from T004ApldMdlCri
where AMCRINO <> AMCD
and AMCRINO <> AMCRIORD
and AMCD <> AMCRIORD;
是不是这样可以符合要求?
select distinct AMCRINO, AMCD, AMCRIORD from T004ApldMdlCri
where AMCRINO <> AMCD
and AMCRINO <> AMCRIORD
and AMCD <> AMCRIORD;
SELECT DISTINCT AMCRIORD as ad ,AMCRINO,AMCD from T004ApldMdlCri));但不行 请帮助
( select max(rowid) id, AMCRINO ao from T004ApldMdlCri
group by AMCRINO ) a,
( select max(rowid) id, AMCD am from T004ApldMdlCri
group by AMCD ) b,
( select max(rowid) id, AMCRIORD ad from T004ApldMdlCri
group by AMCRIORD ) c
WHERE a.id=b.id AND a.id=c.id ;