sql 语句怎么写啊,,把表1里面的数据 通过sql查询,结果弄成表2 的数 ...答:oracle下:--测试数据 SELECT a,b,c FROM (SELECT '李四' a,14 b,6 c FROM dual UNION ALL SELECT '李四',15,3 FROM dual UNION ALL SELECT '李四',16,23 FROM dual UNION ALL SELECT '张三',14,3 FROM dual UNION ALL SELECT '张三',15,4 FROM dual UNION ALL SELECT '张三',16...