sql 行转列

[王双利]

select ip,
case status when 'success' THEN sum(t) ELSE 0 end successct,
case status when 'fail' THEN sum(t) ELSE 0 end failct
from view1
group by ip 这样不能行转列，有解决方案吗？