ããå®ç°åªæ¾ç¤ºä¸ºæå¼çå段ï¼å¯ä»¥éè¿è¡å转æ¢å®ç°ã
ãã以ä¸æ¯ä»¥
sql server为ä¾æ¥è¯´æï¼
ããselect b.stu_name,
ããmax(case a.subject when 'è¯æ' then a.grade else '' end) as è¯æ,
ããmax(case a.subject when 'æ°å¦' then a.grade else '' end) as æ°å¦,
ããmax(case a.subject when 'è±è¯' then a.grade else '' end) as è±è¯
ããfrom stu_grade a,stu_master b
ããwhere a.stu_no=b.stu_no
ããgroup by b.stu_name
ããæ°æ®åºä¸ºoralceçè¯æ§è¡
ããselect b.stu_name,
ããmax(case a.subject when 'è¯æ' then to_char(a.grade) else '' end) as è¯æ,
ããmax(case a.subject when 'æ°å¦' then to_char(a.grade) else '' end) as æ°å¦,
ããmax(case a.subject when 'è±è¯' then to_char(a.grade) else '' end) as è±è¯
ããfrom stu_grade a,stu_master b
ããwhere a.stu_no=b.stu_no
ããgroup by b.stu_name