A: Select @c=1
B: Set @c=1
C: Select @dj=单价 from book order by 单价 desc
D: Set @dj=单价 from book order by 单价 desc
举一反三
- 对于图书管理数据库，检索电子工业出版社的所有图书的书名和书价，检索结果按书价降序排列。下面SQL语句正确的是________。SELECT 书名,单价 FROM 图书 WHERE 出版单位="电子工业出版社"______; A: GROUP BY 单价 DESC B: ORDER BY 单价 DESC C: ORDER BY 单价 ASC D: ORDER BY 单价 ASC
- 对于图书管理数据库，检索电子工业出版社的所有图书的书名和书价，检索结果按书价降序排列。下面SQL语句正确的是（）。SELECT 书名,单价 FROM 图书 WHERE 出版单位="电子工业出版社"（）; A: GROUP BY 单价 DESC<br> B: ORDER BY 单价 DESC<br> C: ORDER BY 单价 ASC<br> D: ORDER BY 单价 ASC
- 在”图书”表中查找单价最低的图书记录，应使用SQL语句是（）。 A: SELECT*FROM图书WHERE单价>=（SELECTMIN（单价）FROM图书） B: SELECT*FROM图书WHERE单价>=ALL（SELECT单价FROM图书） C: SELECT*FROM图书WHERE单价=MIN（单价） D: SELECT*FROM图书WHERE单价=（SELECTMIN（单价）FROM图书）
- 有如下SQL SELECT语句: SELECT *FROM student WHERE age BETWEEN 20 AND 22 与该语句类似的是 A: SELECT * FROM biz WHERE 单价<=15.20 AND 单价>=12.76 B: SELECT * FROM biz WHERE 单价<15.20 AND 单价>12.76 C: SELECT * FROM biz WHERE 单价>=15.20 AND 单价<=12.76 D: SELECT * FROM biz WHERE 单价>15.20 AND 单价<12.76
- 查询book表中每类图书的平均单价，结果只显示平均单价大于30的图书类别名和平均单价，以下SQL语句正确的是？ A: select 图书类别,avg(单价)from bookwhere 单价 >= avg(单价); B: select 图书类别,avg(单价)from bookgroup by 图书类别; C: select 图书类别,avg(单价)from bookgroup by 图书类别having avg(单价) > 30; D: select 图书类别,avg(单价)from bookgroup by 图书类别where avg(单价) > 30;
内容
- 0
下面在sh_goods表中根据cat_id升序排序，当cat_id相同时按price降序排序的语句是（）。 A: SELECT * FROM sh_goods ORDER BY price DESC,cat_id; B: SELECT * FROM sh_goods ORDER BY price ,cat_id; C: SELECT * FROM sh_goods ORDER BY cat_id DESC,price; D: SELECT * FROM sh_goods ORDER BY cat_id,price DESC;
- 1
下列选项中,能够按照 score 由高到低显示 student 表中记录的 SQL 语句是 A: SELECT* FROM student ORDER BY score ; B: SELECT* FROM student ORDER BY score ASC ; C: SELECT * FROM student ORDER BY score DESC ; D: SELECT* FROM student GROUP BY score DESC ;
- 2
下面在sh_goods表中根据cat_id升序排序,并对每个cat_id按price降序排序的语句是( )。[br][/br](1.0) A: SELECT * FROM sh_goods ORDER BY price DESC,cat_id; B: SELECT * FROM sh_goods ORDER BY cat_id,price DESC; C: SELECT * FROM sh_goods ORDER BY price ,cat_id; D: SELECT * FROM sh_goods ORDER BY cat_id DESC,price;
- 3
下列语句用来删除数据表中指定记录，正确的语句是（ ）。 A: DELETE FROM book WHERE 单价>20 B: DELETE * FROM book C: DELETE FROM book HAVING 单价>20 D: DELETE FROM book
- 4
通过 SQL，您如何根据 "FirstName" 列降序地从 "Persons" 表返回所有记录？ A: SELECT * FROM Persons SORT 'FirstName' DESC B: SELECT * FROM Persons ORDER BY FirstName DESC C: SELECT * FROM Persons ORDER FirstName DESC D: SELECT * FROM Persons SORT BY 'FirstName' DESC