select commentId,commentReturn,ReturnA =
(case
when not(commentReturn is null) then '是'
else
'否'
end)
from comment
(case
when not(commentReturn is null) then '是'
else
'否'
end)
from comment
(case
when commentReturn is not null then '是'
else
'否'
end)
from comment