查询老师的姓名、职称和年龄,并重命名,以下哪个方法是正确的?

2023-06-20

查询老师的姓名、职称和年龄,并重命名,以下哪个方法是正确的?

A.Select*FromTeacher

B.SELECTTeachername,Profession,BrithFROMTeacher

C.SELECTTeachername,Profession,2020-YEAR(Brith)FROMTeacher

D.SELECTTeachernameas姓名,Professionas职称,2020-YEAR(Brith)as年龄FROMTeacher



参考答案:

A