Select distinct FunctionType
From
(select FunctionType
from UF
Where OfficeCode='RW'
Order By FunctionCode);
From
(select FunctionType
from UF
Where OfficeCode='RW'
Order By FunctionCode);
From UF
Where OfficeCode='RW'
Order By FunctionCode;
from(
select distinct FunctionCode,FunctionType
from UF
where OfficeCode='RW'
)
order by FunctionCode
glmcglmc(joe)方法:分析很对,但结果无改善.
xbin999(xbin)方法;结果排序正确,但无需FunctionCode字段输出.
xu_guanghui(小风)方法:结果正确!请接分。想不到子查询还可以这样使用^_^