2019年3月26日
sql
摘要： UPDATE student D SET (D.score_sum, D.score_avg) = ( SELECT SUM(B.score) AS s_sum, ROUND(AVG(B.score),1) AS s_avg FROM score B WHERE b.examTime >= '201 阅读全文
posted @ 2019-03-26 15:55 宋songsong 阅读(101) 评论(0) 推荐(0) 编辑