jspælistçè¡å转为åååè¾åºå°é¡µé¢ä¸æè½æç
§åæ¾ç¤ºï¼
æ¯å¦ä»¥ä¸sqlè¯å¥è¾åºæ绩å表æ¯æè¡è½¬ä¸ºåï¼
select t.user_name,
sum(decode(t.course, 'è¯æ', score,null)) as CHINESE,
sum(decode(t.course, 'æ°å¦', score,null)) as MATH,
sum(decode(t.course, 'è±è¯', score,null)) as ENGLISH
from test_tb_grade t
group by t.user_name
order by t.user_name
以ä¸ç»ææ¥è¯¢åºæ¥åå°è£
å°listä¸ï¼ç¶åç¨jstlæ ç¾è¿ä»£å°±æ¯åæ¾ç¤ºäºã
温馨提示:内容为网友见解,仅供参考