数据库中有一张表名称为Student,有列Number,Name,Age,IDCard,Sex。主键为Number。统计学生总人数,下列哪个SQL语句是正确的()
A.Select Count(1)From Student
B.Select Sum(*)From Student
C.Selec tAvg(*)From Student
D.Select Count(*)From Student
A.Select Count(1)From Student
B.Select Sum(*)From Student
C.Selec tAvg(*)From Student
D.Select Count(*)From Student
A. Select Count(1)From Student
B. Select Sum(*)From Student
C. Selec tAvg(*)From Student
D. Select Count(*)From Student
A. Select* From Student
B. Select Name From Student
C. Select Name,Age,IDCard From Student
D. Select Name,Age,IDCard,Sex From Student
A、Select * From Student
B、Select Name From Student
C、Select Name,Age,IDCard From Student
D、Select Name Age IDCard Sex From Student
A. Delete Student‘20140001’
B. Delete Student“20140001”
C. Delete Student Where Number=‘20140001’"
D. Delete From Student Where Number=”20140001”"
A. Select* From Student Where Sex=’男’
B. Select* From Student Where Number NotIn(Select Number From Student Where Sex<>=’男’)
C. Select* From Student Where NumberIn(Select Numbe rFrom Student Where Sex=’男’)
D. Select* From Student Where Sex<>’男&rsquo
B、Select * From Student Where Number Not In(Select Number From Student Where Sex<>=’男’)
C、Select * From Student Where Number In(Select Number From Student Where Sex =’男’)
D、Select * From Student Where Sex<>’男’
A.Select* From Student Where Sex=’男’
B.Select* From Student Where Number NotIn(Select Number From Student Where Sex<>=’男’)
C.Select* From Student Where NumberIn(Select Numbe rFrom Student Where Sex=’男’)
D.Select* From Student Where Sex<>’男&rsquo
A.Delete Student‘20140001’
B.Delete Student“20140001”
C.Delete Student Where Number=‘20140001’"
D.Delete From Student Where Number=”20140001”"
A.Select*FromStudentWhereSex=’男’
B. Select*FromStudentWhereSex<>’女’
C. Select*FromStudentWhereSexLike’男’
D. Select*FromStudentWhereSexIn’男&rsquo
为了保护您的账号安全,请在“简答题”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!