查找学生表student中姓名的第二个字为"t"的学生学号sno和姓名sname,下面SQL语句正确的是()
A.SELECTsno,snameFROMstudentWHEREsname=’_t%’;
B.SELECTsno,snameFROMstudentWHEREsnameLIKE’_t%’;
C.SELECTsno,snameFROMstudentWHEREsname=’%t_’;
D.SELECTsno,snameFROMstudentWHEREsnameLIKE’%t_’;
A.SELECTsno,snameFROMstudentWHEREsname=’_t%’;
B.SELECTsno,snameFROMstudentWHEREsnameLIKE’_t%’;
C.SELECTsno,snameFROMstudentWHEREsname=’%t_’;
D.SELECTsno,snameFROMstudentWHEREsnameLIKE’%t_’;
A、student.sno=sc.sno and sc.cno=course.cno and cname='Java程序设计'
B、cname='Java程序设计'
C、student.sno=sc.sno and cname='Java程序设计'
D、sc.cno=course.cno and cname='Java程序设计'
A、INSERT INTO tb_student (sno, sname, sex, age, dept, native) VALUES('s320078', '张强','男',20, '计算机');
B、INSERT INTO tb_student (sno, sname, sex, age, dept) VALUES('s320078', '张强','男',20, '计算机');
C、INSERT INTO tb_student VALUES('s320078', '张强','男',20, '计算机',null);
D、INSERT INTO tb_student (dept, sno, sname, sex, age) VALUES('计算机', 's320078', '张强','男',20);
A. select sname,age from xsb where age>20and age<23B. select*from xsb where age between20 and 23C. select sname,age from xsb where agebetween20 and 23
A.b.cno
B.b.sno
C.SELECTasno,sname,cno,cjFROMscaCROSSJOINcoursesbONa.cno
D.SELECTa.sno,sname,cno,cjFROMstudentsaJOINscbONa.sno
E.SELECTa.sno,sname,cno,cjFROMstudentsaCROSSJOINscbONa.sno
F.SELECTa.sno,sname,cno,cjFROMscaJOINsoursesbONa.cno
B.6%
C.与1年期债券利率无关
D.是一年期债券利率的函数
B.人生态度
C.人生价值
D.人生价值观
为了保护您的账号安全,请在“简答题”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!