网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
使用SQL语句从表STUDENT中查询所有姓王的同学的信息,正确的命令是:A)SELECT*FROM STUDENT WHERE LEFT(姓名,2)=“王”B)SELECT*FROM STUDENT WHERE RIGHT(姓名,2)=“王”C)SELECT*FROM STUDENT WHERE TRIM(姓名,2)=“王”D)SELECT*FROM STUDENT WHERE STR(姓名,2)=“王”
参考答案
更多 “ 使用SQL语句从表STUDENT中查询所有姓王的同学的信息,正确的命令是:A)SELECT*FROM STUDENT WHERE LEFT(姓名,2)=“王”B)SELECT*FROM STUDENT WHERE RIGHT(姓名,2)=“王”C)SELECT*FROM STUDENT WHERE TRIM(姓名,2)=“王”D)SELECT*FROM STUDENT WHERE STR(姓名,2)=“王” ” 相关考题
考题
使用SQL语句查询学生信息表tbl_student中的所有数据,并按学生学号stu_id升序排列,正确的语句是()
A、SELECT*FROMtbl_studentORDERBYstu_idASC;B、SELECT*FROMtbl_studentORDERBYstu_idDESC;C、SELECT*FROMtbl_studentstu_idORDERBYASC;D、SELECT*FROMtbl_studentstu_idORDERBYDESC;
考题
设有学生数据库:student(sno,sname,sex,age,dept)。现要查询所有刘姓学生的信息,可使用如下的 SQL语句:SELECT*FROM student WHERE【 】。
考题
使用SQL语句从表STUDENT中查询所有姓王的同学的信息,正确的命令是:______。A.SELECT*FROM STUDENT WHERE LEFT(姓名,2)=“王”B.SELECT*FROM STUDENT WHERE RIGHT(姓名,2)=“王”C.SELECT*FROM STUDENT WHERE TRIM(姓名,2)=“王”D.SELECT*FROM STUDENT WHERE STR(姓名,2)=“王”
考题
对于学生信息表:student(sno,sname,sex,age,dept),要查询所有刘姓学生的信息,正确的语句是A.SELECT * FROM student WHERE sname LIKE'刘 * 'B.SELECT * FROM student WHERE sname LIKE'刘 $'C.SELECT * FROM student WHERE sname LIKE'刘%'D.SELECT * FROM student WHERE sname LIKE'刘'
考题
使用SQL语句从表STUDENT中查询所有姓王的同学的信息,正确的命令是:A.SELECT*FROM STUDENT WHERE LEFT(姓名,2)=“王”B.SELECT*FROM STUDENT WHERE RIGHT(姓名,2)=“王”C.SELECT*FROM STUDENT WHERE TRIM(姓名,2)=“王”D.SELECT*FROM STUDENT WHERE STR(姓名,2)=“王”
考题
从数据表student中查询张姓的所有学生,正确的SQL语句是()。A.SELECT sno,sname FROM student WHERE sname LIKE N'张%'B.SELECT sno,sname FROM student WHERE sname LIKE N'%张%'C.SELECT sname FROM student WHERE sname = N'张%'D.SELECT sname FROM student WHERE sname = N'%张%'
考题
从学生表student查询学生的所有信息,正确的语句是______。A.SELECT # FROM studentB.SELECT * FROM studentC.SELECT ? FROM studentD.SELECT _ FROM student
考题
6、从学生表student查询学生的所有信息,正确的语句是______。A.SELECT # FROM studentB.SELECT * FROM student;C.SELECT ? FROM student;D.SELECT _ FROM student;
考题
1、从学生表student查询学生的所有信息,正确的语句是______。A.SELECT # FROM studentB.SELECT * FROM studentC.SELECT ? FROM studentD.SELECT _ FROM student
热门标签
最新试卷