执行语句“SELECT5=’5ab’;”结果为() A: 1 B: 0 C: NULL D: error!
执行语句“SELECT5=’5ab’;”结果为() A: 1 B: 0 C: NULL D: error!
假定x的值为5,则在执行以下语句时,其输出结果为"Result"的正确表示Select Case语句是( ) A: Select Case x Case 1 To 10 Print "Result" End Select B: Select Case x Case Is>5,Is<5 Print "Result" End Select C: Select Case x Case Is>5,1,3 To 4 Print "Result" End Select D: Select Case x Case 1,3,Is>5 Print "Result" End Select
假定x的值为5,则在执行以下语句时,其输出结果为"Result"的正确表示Select Case语句是( ) A: Select Case x Case 1 To 10 Print "Result" End Select B: Select Case x Case Is>5,Is<5 Print "Result" End Select C: Select Case x Case Is>5,1,3 To 4 Print "Result" End Select D: Select Case x Case 1,3,Is>5 Print "Result" End Select
假设X的值是5,则执行以下语句时,可得到的输出结果是ABCDEF的Select Case语句是 ( ) A: Select Case X Case 10 To 1 Print“ABCDEF” End Select B: Select Case X Case Is>15,Is<5 Print"ABCDEF" End Select C: Selecl Case K Case Is>5,1,3,To 10 Print"ABCDEF" End Select D: Select Case X Case 1,3,Is>5 Print"ABCDEF" End Select
假设X的值是5,则执行以下语句时,可得到的输出结果是ABCDEF的Select Case语句是 ( ) A: Select Case X Case 10 To 1 Print“ABCDEF” End Select B: Select Case X Case Is>15,Is<5 Print"ABCDEF" End Select C: Selecl Case K Case Is>5,1,3,To 10 Print"ABCDEF" End Select D: Select Case X Case 1,3,Is>5 Print"ABCDEF" End Select
查询“学生表t_student”中的前5条记录,字段为学号和姓名。 A: SELECT TOP 5 student_no, student_name<br/>FROM t_student B: SELECT LIMIT 5 student_no, student_name<br/>FROM t_student C: SELECT TOP 5 student_no, student_name<br/>FROM D: SELECT 5 student_no, student_name<br/>FROM t_student
查询“学生表t_student”中的前5条记录,字段为学号和姓名。 A: SELECT TOP 5 student_no, student_name<br/>FROM t_student B: SELECT LIMIT 5 student_no, student_name<br/>FROM t_student C: SELECT TOP 5 student_no, student_name<br/>FROM D: SELECT 5 student_no, student_name<br/>FROM t_student
在“成绩”表中,查找出“期末”成绩排在前5位的记录,正确的SQL命令是( ) A: SELECT TOP 5 期末 FROM 成绩 GROUP BY 期末 DESC B: SELECT TOP 5 期末 FROM 成绩 GROUP BY 期末 C: SELECT TOP 5 期末 FROM 成绩 ORDER BY 期末 DESC D: SELECT TOP 5 期末 FROM 成绩 ORDER BY 期末
在“成绩”表中,查找出“期末”成绩排在前5位的记录,正确的SQL命令是( ) A: SELECT TOP 5 期末 FROM 成绩 GROUP BY 期末 DESC B: SELECT TOP 5 期末 FROM 成绩 GROUP BY 期末 C: SELECT TOP 5 期末 FROM 成绩 ORDER BY 期末 DESC D: SELECT TOP 5 期末 FROM 成绩 ORDER BY 期末
下面选项中,查询student表中id值不在2和5之间的SQL语句是( )。 A: SELECT * FROM `student` WHERE `id`!=2,3,4,5 B: SELECT * FROM `student` WHERE `id` NOT BETWEEN 5 AND 2 C: SELECT * FROM `student` WHERE `id` NOT BETWEEN 2 AND 5 D: SELECT * FROM `student` WHERE `id` NOT IN 2,3,4,5
下面选项中,查询student表中id值不在2和5之间的SQL语句是( )。 A: SELECT * FROM `student` WHERE `id`!=2,3,4,5 B: SELECT * FROM `student` WHERE `id` NOT BETWEEN 5 AND 2 C: SELECT * FROM `student` WHERE `id` NOT BETWEEN 2 AND 5 D: SELECT * FROM `student` WHERE `id` NOT IN 2,3,4,5
查询student表中id字段值小于5,并且gender字段值为“女”的学生姓名的SQL语句是() A: SELECT name FROM student WHERE id<;5 OR gender='女'; B: SELECT name FROM student WHERE id<;5 AND gender='女'; C: SELECT name FROM student WHERE id<;5 ,gender='女'; D: SELECT name FROM student WHERE id<;5 AND WHERE gender='女';
查询student表中id字段值小于5,并且gender字段值为“女”的学生姓名的SQL语句是() A: SELECT name FROM student WHERE id<;5 OR gender='女'; B: SELECT name FROM student WHERE id<;5 AND gender='女'; C: SELECT name FROM student WHERE id<;5 ,gender='女'; D: SELECT name FROM student WHERE id<;5 AND WHERE gender='女';
select abs(5),abs(-3.5)的值为
select abs(5),abs(-3.5)的值为
【单选题】在"成绩"表中,查找出"考试成绩排在前5位的记录,正确的SQL命令是()? A. SELECT TOP 5 考试成绩 FROM 成绩GROUP BY 考试成绩 DESC B. SELECT TOP 5 考试成绩 FROM 成绩 GROUP BY 考试成绩 C. SELECT TOP 5 考试成绩 FROM 成绩 ORDER BY 考试成绩 DESC D. SELECT TOP 5考试成绩 FROM 成绩 ORDER BY 考试成绩
【单选题】在"成绩"表中,查找出"考试成绩排在前5位的记录,正确的SQL命令是()? A. SELECT TOP 5 考试成绩 FROM 成绩GROUP BY 考试成绩 DESC B. SELECT TOP 5 考试成绩 FROM 成绩 GROUP BY 考试成绩 C. SELECT TOP 5 考试成绩 FROM 成绩 ORDER BY 考试成绩 DESC D. SELECT TOP 5考试成绩 FROM 成绩 ORDER BY 考试成绩
下面选项中,查询student表中id值不在2和5之间的学生的SQL语句是 A: SELECT * FROM student where id!=2,3,4,5; B: SELECT * FROM student where id not between 5 and 2; C: SELECT * FROM student where id not between 2 and 5; D: SELECT * FROM student where id not in 2,3,4,5;
下面选项中,查询student表中id值不在2和5之间的学生的SQL语句是 A: SELECT * FROM student where id!=2,3,4,5; B: SELECT * FROM student where id not between 5 and 2; C: SELECT * FROM student where id not between 2 and 5; D: SELECT * FROM student where id not in 2,3,4,5;