问题描述:
关于SQL语句里面的A.XX,和B.
select B.kecheng,B.score,B.xuehao
from(select kecheng ,max(score) AS score from jiaScore group by kecheng) A,jiaScore B
where A.kecheng = B.kecheng
and A.score = B.score
例如我这段数据库语句,A.kecheng和B.kecheng 中的AB都是代表着什么?
select B.kecheng,B.score,B.xuehao
from(select kecheng ,max(score) AS score from jiaScore group by kecheng) A,jiaScore B
where A.kecheng = B.kecheng
and A.score = B.score
例如我这段数据库语句,A.kecheng和B.kecheng 中的AB都是代表着什么?
问题解答:
我来补答展开全文阅读