假设表1的3个字段名字分别为name,date,scoreselect distinct name,(select score from table1 where a.name=name and date='14')as '14',(select score from table1 where a.name=name and date='15')as '15',(select score from table1 where a.name=name and date='16')as '16'from table1 a大概这样吧,你试试先...
