摘要:
SQL Server把行转列:如以下表:当表中只有少量数据时,可以采用静态SQL语句如:select stuName ,max(case Course when '语文' then score else 0 end) as 语文,max(case Course when '数学' then score else 0 end) as 数学,max(case Course when '英语' then score else 0 end) as 英语,max(case Course when '物理' then score else 0 阅读全文