Question

已知两个表,分别为test1.test2如下图所示,要求用select语句,将表test1变为test2

oracle

Answer 1

select distinct 姓名 as 姓名,distinct (select 分数 from test1 where 科目='语文') as 语文，distinct (select 分数 from test1 where 科目='数学') as 数学 from test1