錯誤碼： 1248 Every derived table must have its own alias，1248derived

錯誤碼： 1248 Every derived table must have its own alias，1248derived

1、錯誤描述

1 queries executed, 0 success, 1 errors, 0 warnings查詢：SELECT stu_id, (SELECT stu_name FROM t_student_info t WHERE t.stu_id = t.stu_id) stu_name FROM (SELECT SUM( CASE course WHEN '敮..錯誤碼： 1248Every derived table must have its own alias執行耗時   : 0 sec傳送時間   : 0 sec總耗時      : 0 sec

2、錯誤原因

SELECT   stu_id,  (SELECT     stu_name   FROM    t_student_info t   WHERE t.stu_id = t.stu_id) stu_name FROM  (SELECT     SUM(      CASE        course         WHEN '數學'         THEN Score         ELSE 0       END    ) 數學,    SUM(      CASE        course         WHEN '語文'         THEN score         ELSE 0       END    ) 語文,    SUM(      CASE        course         WHEN '英語'         THEN score         ELSE 0       END    ) 英語,    stu_id   FROM    t_score_info   GROUP BY stu_id)

3、解決辦法