题目内容

删除student表中id为1的记录（）

A. TRUNCATE FROM student where id=1;
B. DELETE student where id=1;
C. DELETE FROM student where id=1;
DELETE INTO student where id=1;

查看答案

搜索结果不匹配？点我反馈

更多问题

查询student表age值在16～20之间的name值（）

A. SELECT name FROM student WHERE age BETWEEN 16 AND 20
B. SELECT name FROM student WHERE age NOT BETWEEN 16 AND 20
C. SELECT name FROM student WHERE age IN(16,20)
D. SELECT name FROM student WHERE age NOT IN(16,20)

查看答案

查询student表中name字段值第二个字符为'u',最后一个字符为'g'的学生id（）

A. SELECT id FROM student WHERE name LIKE '%u%g'
B. SELECT id FROM student WHERE name LIKE '_u_g'
C. SELECT id FROM student WHERE name LIKE '_u%g'
D. SELECT id FROM student WHERE name LIKE '_u%g'%

查看答案

查询student表中的所有记录，按照grade字段升序排列，按照gender字段降序排列（）

A. SELECT * FROM student ORDER BY grade,gender ASC
B. SELECT * FROM student ORDER BY grade DESC,gender DESC
C. SELECT * FROM student ORDER BY grade DESC,gender ASC
D. SELECT * FROM student ORDER BY grade ASC,gender DESC

查看答案

查询student表中grade字段值从第5位到第8位的学生（从高到第）（）

A. SELECT * FROM student ORDER BY grade DESC LIMIT 5,8
B. SELECT * FROM student ORDER BY grade LIMIT 5,8
C. SELECT * FROM student ORDER BY grade LIMIT 4,4
D. SELECT * FROM student ORDER BY grade DESC LIMIT 4,4

查看答案

删除student表中id为1的记录（）

A. TRUNCATE FROM student where id=1; B. DELETE student where id=1; C. DELETE FROM student where id=1; DELETE INTO student where id=1;

查询student表age值在16～20之间的name值（）

查询student表中name字段值第二个字符为'u',最后一个字符为'g'的学生id（）

查询student表中的所有记录，按照grade字段升序排列，按照gender字段降序排列（）

查询student表中grade字段值从第5位到第8位的学生（从高到第）（）

A. TRUNCATE FROM student where id=1;
B. DELETE student where id=1;
C. DELETE FROM student where id=1;
DELETE INTO student where id=1;