错误代码: 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 '敮.. 错误代码: 1248 Every 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、解决办法
本站文章为和通数据库网友分享或者投稿,欢迎任何形式的转载,但请务必注明出处.
同时文章内容如有侵犯了您的权益,请联系QQ:970679559,我们会在尽快处理。