oracle中判断某个字段是否存在
oracle中判断某个字段是否存在
select name,sum(decode(subject,'语文', grade,null)) "语文", sum(decode(subject,'数学', grade,null)) "数学", sum(decode(subject,'英语', grade,null)) "英语" from student group by name ?
发布时间: 2012-09-04 14:19:30 作者: rapoo
oracle中判断某个字段是否存在
oracle中判断某个字段是否存在
select name,sum(decode(subject,'语文', grade,null)) "语文", sum(decode(subject,'数学', grade,null)) "数学", sum(decode(subject,'英语', grade,null)) "英语" from student group by name ?