A: A.SELECT * FROM stud ORDER BY birthday DESC LIMIT 8;
B: B.SELECT * FROM stud ORDER BY birthday ASC LIMIT 8;
C: C.SELECT * FROM stud ORDER BY birthday ASC LIMIT 7;
D: D.SELECT * FROM stud ORDER BY birthday DESC LIMIT 7;
举一反三
- 在stud表中返回年龄最小的8位同学的信息，使用（ ） A: SELECT * FROM studORDER BY birthday DESCLIMIT 8; B: SELECT * FROM studORDER BY birthday ASCLIMIT 8; C: SELECT * FROM studORDER BY birthday ASCLIMIT 7; D: SELECT * FROM studORDER BY birthday DESCLIMIT 7;
- 查询主键id从高到低排序的前10条记录的语句是（） A: SELECT * FROM table ORDER BY id ASC limit 1,10 B: SELECT * FROM table ORDER id DESC limit 10 C: SELECT * FROM table ORDER BY id DESC limit 10 D: SELECT * FROM table ORDER id ASC limit 1,10
- 有学生表,其结构为: student(学号, 姓名, 性别, 年龄), 查询所有年龄小于等于18岁的女同学、并按年龄降序排序生成新的表stud,正确的SQL命令是______。 A: CREATE TABLE stud AS SELECT * FROM student WHERE 性别='女' AND 年龄<;=18 ORDER BY 年龄; B: CREATE TABLE stud AS SELECT * FROM student WHERE 性别='女' AND 年龄<;=18 ORDER BY '年龄' DESC; C: CREATE TABLE stud AS SELECT * FROM student WHERE 性别='女' AND 年龄<;=18 ORDER BY '年龄' ASC; D: CREATE TABLE stud AS SELECT * FROM student WHERE 性别='女' AND 年龄<;=18 ORDER BY 年龄 DESC;
- 有学生表，其结构为：<br/>student(学号, 姓名, 性别, 年龄)，<br/>查询所有年龄小于等于18岁的女同学、并按年龄降序排序生成新的表stud，正确的SQL命令是______。 A: CREATE TABLE stud AS<br/>SELECT * FROM student WHERE 性别='女' AND 年龄<=18 ORDER BY 年龄; B: CREATE TABLE stud AS<br/>SELECT * FROM student WHERE 性别='女' AND 年龄<=18 ORDER BY '年龄' DESC; C: CREATE TABLE stud AS<br/>SELECT * FROM student WHERE 性别='女' AND 年龄<=18 ORDER BY '年龄' ASC; D: CREATE TABLE stud AS<br/>SELECT * FROM student WHERE 性别='女' AND 年龄<=18 ORDER BY 年龄 DESC;
- 在SELECT语句中,与排序有关的关键字是______。 A: ORDER BY B: LIMIT C: DESC D: ASC E: ： ACD F: 、查询1997,1999年出生的同学信息,正确的SELECT语句是______。 G: SELECT * FROM student WHERE YEAR(birthday) NOT IN(1997,1999); H: SELECT * FROM student WHERE YEAR(birthday)=1997 OR YEAR(birthday)=1999; I: SELECT * FROM student WHERE YEAR(birthday) IN(1997,1999); J: SELECT * FROM student WHERE YEAR(birthday) EXISTS(1997,1999);
内容
- 0
在学生表STUD中查询所有姓张的学生的信息，使用的SQL语句是______。 A: SELECT*FROM STUD WHERE 姓名 LIKE"张%” B: SELECT*FROM STUD WHERE 姓名 IN("张%") C: SELECT*FROM STUD WHERE 姓名 LIKE"张$" D: SELECT*FROM STUD WHERE 姓名 IN"张$)"
- 1
从工资表中查询工资最高的3位职工的全部信息，正确的命令是（ ）。 A: SELECT * FROM 职工 ORDER BY 工资 DESC LIMIT 3 B: SELECT ALL FROM 职工 ORDER BY 工资DESC C: SELECT * TOP 3 FROM 职工 ORDER BY 工资 D: SELECT DISTINCT 工资 TOP 3 FROM 职工 ORDER BY 工资DESC
- 2
有一“职工”表，要对所有的职工先按性别的降序排序，在性别相同的情况下再按工资的升序排序，使用的SQL语句是（ ）。 A: SELECT * FROM 职工 ORDER BY 性别 ASC, 工资 DESC B: SELECT * FROM 职工 ORDER BY 性别 ASC, 工资 ASC C: SELECT * FROM 职工 ORDER BY 性别 DESC, 工资 DESC D: SELECT * FROM 职工 ORDER BY 性别 DESC, 工资
- 3
查询学生的姓名、出生年月,最准确的SQL语句是(<br/>)。 A: SELECT<br/>* FROM students B: SELECT<br/>s_name,birthday FROM students C: SELECT<br/>s_name,birthday,phone FROM students D: SELECT<br/>s_name,birthday FROM students ORDER BY birthday
- 4
查询学生成绩，将成绩首先按英语，然后按数学从高到低排序，正确的语句是（ ）。 A: select * from score order by english asc,maths asc B: select * from score order by english desc,maths desc C: select * from score order by maths,english D: select * from score order by english,maths