纵表转横表 纵表: 横表: sql: SELECT s.DATA, sum( CASE s.NAME WHEN 'tom' THEN 1 end ) AS tom, sum( CASE s.NAME WHEN 'cat' THEN 1 end ) AS cat FROM info s GROUP BY s. DATA;