SELECT语句的作用是从表中________指定的字段?
查看答案
查询老师的姓名、职称和年龄,并重命名,以下哪个方法是正确的?
A. Select * From Teacher
B. SELECT Teachername ,Profession ,Brith FROM Teacher
C. SELECT Teachername ,Profession ,2020-YEAR(Brith) FROM Teacher
D. SELECT Teachername as 姓名 ,Profession as 职称 ,2020-YEAR(Brith) as 年龄 FROM Teacher
从XKGL数据库中的student表中选取学号、姓名、性别的操作,以下操作代码正确的是:
A. USE [xkgl]GOSELECT [StudentID] AS 学号,[StudentName] AS 姓名,[Sex] AS 性别 FROM [dbo].[Student]GO
B. USE [xkgl]GOSELECT [StudentID],[StudentName],[Sex] FROM [dbo].[Student]GO
C. USE xkglGOSELECT StudentID,StudentName,Sex FROM StudentGO
D. USE xkglGOSELECT StudentID,StudentName,ClassID FROM StudentGO
在XKGL数据库中,查询所有老师信息的操作是:Select ____ from Teacher请补全该代码
在XKGL数据库中,查询每个班的班名和班长的方法是:SELECT ___________as 班级名, ___________as 班长FROM Class(注意大小写与列名保持一致)