查询老师的姓名、职称和年龄,并重命名,以下哪个方法是正确的?
10 查阅
查询老师的姓名、职称和年龄,并重命名,以下哪个方法是正确的?
A.Select*FromTeacher
B.SELECTTeachername,Profession,BrithFROMTeacher
C.SELECTTeachername,Profession,2020-YEAR(Brith)FROMTeacher
D.SELECTTeachernameas姓名,Professionas职称,2020-YEAR(Brith)as年龄FROMTeacher
参考答案: