不能使用IF,可以用case when来做select id,name,created,
case when len(id)>2 then (select max(created) as a)
else
(select min(created) as b)
end
from acc;
case when len(id)>2 then (select max(created) as a)
else
(select min(created) as b)
end
from acc;
(case when length(acc.id)>2 then
(select max(a1.created) from acc a1
)
else
(select min(a1.created) from acc a1
)
end
) a
from acc
select id,name,created,
DECODE(GREATEST(len(id),2),2,max(created),min(created)) A
from acc;