试试这个
select A.fzhbs,B.cou,decode(B.cou,1,A.yhbs,A.fzhbs)
from test A, (select fzhbs,count(*) as cou from test group by fzhbs) B;
select A.fzhbs,B.cou,decode(B.cou,1,A.yhbs,A.fzhbs)
from test A, (select fzhbs,count(*) as cou from test group by fzhbs) B;
count(distinct yhbs),
case count(distinct yhbs)
when 1 then yhbs
else fzhbs
end
from test group by fzhbs;