Question

高手请教啊，，怎么用sql 语句 把表1 里面的数据查询出来显示的是表2 的样式？？高手来啊

回答对的打分送上

Answer 1

假设表1的3个字段名字分别为name,date,score
select 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
大概这样吧,你试试先