TonnyisanstudentfromAmericawholivesinthehostfamil-X题卡

在Transact-SQL语法中以下SELECT语句正确的是

SELECT * FROM student SELECT * FROM student WHERE GETDATE（） SELECT * FROM student ORDER st_id SELECT * FROM student BY St_name

在SQLServer数据库中已有数据表student可以删除该表数据的命令是

DROP FROM student DELETE FROM student REMOVE FROM student KILL FROM student

对于学生信息表studentsnosnamesexagedept要查询所有刘姓学生的信息正确的语句是

SELECT * FROM student WHERE sname LIKE'刘 * ' SELECT * FROM student WHERE sname LIKE'刘 $' SELECT * FROM student WHERE sname LIKE'刘%' SELECT * FROM student WHERE sname LIKE'刘&'

与SQL语句SELECT学号姓名FROMstudentWHERE成绩BETWEEN60AND100等

SELECT学号，姓名 FROM student WHERE成绩＜=100.AND.成绩＞=60 SELECT学号，姓名 FROM student WHERE成绩＜100.AND.成绩＞60 SELECT学号，姓名 FROM student WHERE成绩＞=100.AND.成绩＜=60 SELECT学号，姓名 FROM student WHERE成绩＞100.AND.成绩＜60

对于学生信息表studentsnosnamesexagedept能够得到年龄在20～22岁之间的学生

SELECF FROM student WHERE age BETWEEN 20 AND 22 SELECT sname, sno FROM student WHERE age BETWEEN 20 AND 22 SELECT sname, sno FROM student WHERE age＞=20 SELECT sname, sno FROM student WHERE age＜=22

阅读理解阅读托尼Tonny的家谱选择正确答案1.BobisMartinBrown's______.A

与SQL语句SELECT学号姓名FROMstudentWHERE成绩BETWEEN60AND100等

SELECT 学号,姓名 FROM student WHERE 成绩＜=100.AN成绩＞＝60 SELECT 学号,姓名 FROM student WHERE 成绩＜100.AN成绩＞60 SELECT 学号,姓名 FROM student WHERE 成绩＞=100.AN成绩＜=60 SELECT 学号,姓名 FROM student WHERE 成绩＞100.AN成绩＜60

阅读理解阅读托尼Tonny的家谱选择正确答案1.BobisMartinBrown's______.A

对于数据表studentsnosnamesexagegrade查询学习成绩为空的学生的学号和姓名下面

SELECT sno,sname FROM student WHERE grade=NULL SELECT sno,sname FROM student WHERE grade IS NULL SELECT sno,age FROM student WHERE grade IS NULL SELECT sno,age FROM student WHERE grade=NULL

对于学生信息表studentsnosnamesexagegrade查询学习成绩为空的学生的学号和姓名

SELECT Sno，sname FROM student WHERE grade=NULL SELECT sno，sname FROM student WHERE grade IS NULL SELECT sno，age FROM student WHERE grade IS NULL SELECT sno，age FROM student WHERE grade=NULL

从学生表中删除学号为1001的学生记录正确的SQL语句是______

DROP FROM Student WHERE 学号="1001" DROP FROM Student FOR 学号="1001" DELETE FROM Student WHERE 学号="1001" DELETE FROM Student FOR 学号="1001"

对于学生信息表studentsnosnamesexagegrade查询学习成绩为空的学生的学号和姓名

SELECT sno，sname FROM student WHERE grade=NULL SELECT sno，sname FROM student WHERE grade IS NULL SELECT sno，age FROM student WHERE grade IS NULL SELECT sno，age FROM student WHERE grade=NULL

与SQL语句SELECT学号姓名FROMstudentWHERE成绩BETWEEN60AND100等

SELECT 学号,姓名 FROM student WHERE 成绩＜=100.AND.成绩＞＝60 SELECT 学号,姓名 FROM student WHERE 成绩＜100.AND.成绩＞60 SELECT 学号,姓名 FROM student WHERE 成绩＞=100.AND.成绩＜=60 SELECT 学号,姓名 FROM student WHERE 成绩＞100.AND.成绩＜60

对于学生信息表studentsnosnamesexagedept能够得到年龄在20岁到22岁之间的学

SELECT * FROM student WHERE age BETWEEN 20 AND 22 SELECT sname，sno FROM student WHERE age BETWEEN 20 AND 22 SELECT sname，sno FROM student WHERE age＞=20 SELECT sname，sno FROM student WHERE age＜=22

下列各题使用如下表Student.dbf学号姓名课程号成绩从学生表中删除学号为1001的学生记录正确

DROP FROM Student WHERE学号="1001" DROP FROM Student FOR学号="1001" DELETE FROM Student WHERE学号="1001" DELETE FROM Student FOR学号="1001"

已知有关系STUDENT则关系运算σANE＜80STUDENT用SQL语句表示为

SELECT( * )FROM STUDENT WHERE AVE ＜ 80 SELECT( * ) FROM STUDENT HAVING AVE ＜ 80 SELECT(AVE) FROM STUDENT WHERE AVE ＜ 80 SELECT(AVE） FROM STUDENT HAVING AVE ＜ 80

对于数据表studentsnosnamesexagegrade查询学习成绩为空的学生的学号和姓名下面

SELECT sno,sname FROM student WHERE gade=NULL SELECT sno,sname FROM student WHERE grade IS NULL SELECT sno,age FROM student WHERE grade IS NULL SELECT mo,age FROM student WHERE grade=NULL

已知有关系STUDENT则关系运算σANE＜80STUDENT用SQL语句表示为52

SELECT( * )FROM STUDENT WHERE AVE ＜ 80 SELECT( * ) FROM STUDENT HAVING AVE ＜ 80 SELECT(AVE) FROM STUDENT WHERE AVE ＜ 80 SELECT(AVE） FROM STUDENT HAVING AVE ＜ 80

使用SQL语句从表STUDENT中查询所有姓王的同学的信息正确的命令是______

SELECT*FROM STUDENT WHERE LEFT(姓名，2)=“王” SELECT*FROM STUDENT WHERE RIGHT(姓名，2)=“王” SELECT*FROM STUDENT WHERE TRIM(姓名，2)=“王” SELECT*FROM STUDENT WHERE STR(姓名，2)=“王”

Tonny is an 　　 student from America, who lives in the host family in France.

包含此试题的试卷

你可能感兴趣的试题

热门试题

热门题库

Tonny is an student from America, who lives in the host family in France.

包含此试题的试卷

你可能感兴趣的试题

热门试题

热门题库

Tonny is an 　　 student from America, who lives in the host family in France.