读书人

oracle中判断某个字段是不是存在

发布时间: 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

?

读书人网 >软件架构设计

热点推荐