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

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

A.Select*FromTeacher

B.SELECTTeachername,Profession,BrithFROMTeacher

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

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

正确答案:A

猜你喜欢