现有书目表book，包含字段：price（float）；现在查询一条书价最高的书目的详细信息，以下语句正确的是（）

A、select top 1 * from book order by price asc

B、select top 1 * from book order by price desc

C、select top 1 * from book where price= (select max (price)from book)

D、select top 1 * from book where price= max(price)

查看正确答案

更多“现有书目表book，包含字段：price（float）；现在查询一条书价最高的书目的详细信息，以下语句正确的是（）”相关的问题

第1题

[多选题] BookStore数据库中有图书表Book（BookCode，BookName，Author，PublisherCode，PublishTimePublishTime是datetime类型。将Book表中的所有“外语”类图书的价格降低10%，并将折扣均设为8折。SQL语句：UPDATEBookSET（）WhereBookSort=‘外语‘。

A、Price=Price*0.9，Discount=0.8 B、Price=Price*（1-10%），Discount=0.8 C、Price=0.9，Discount=0.8 D、Discount=0.8，Price=Price*0.9

点击查看答案

第2题

[] 有一个“出版物”表，包含图书编码（Book-code），书名（Book-name），出版日期（Issue-dt），备注（Mem-cd）等字段，（）字段作为该表的主键可能是最恰当的。

A、A.Book-code B、B.Book-name C、C.Issue-dt D、D.Mem-cd

点击查看答案

第3题

[] 下面有关Excel工作表、工作簿的说法中，正确的是（）。

A、A.一个工作簿可包含多个工作表，缺省工作表名为Sheet1/sheet2/sheet3 B、B.一个工作簿可包含多个工作表，缺省工作表名为Book1/book2/book3 C、C.一个工作表可包含多个工作簿，缺省工作表名为Sheet1/sheet2/sheet3 D、D.一个工作表可包含多个工作簿，缺省工作表名为Book1/book2/book3

点击查看答案

第4题

[单选题] You want to display the titles of books that meet these criteria: 1. Purchased before January 21, 2001 2. Price is less then $500 or greater than $900 You want to sort the results by their data of purchase, starting with the most recently bought book. Which statement should you use?（）

A、SELECT book_title FROM books WHERE price between 500 and 900 AND purchase_date < '21-JAN-2001' ORDER BY purchase_date; B、SELECT book_title FROM books WHERE price IN (500,900) AND purchase_date < '21-JAN-2001' ORDER BY purchase date ASC; C、SELECT book_title FROM books WHERE price < 500 or > 900 AND purchase_date < '21-JAN-2001' ORDER BY purchase date DESC; D、SELECT book_title FROM books WHERE (price < 500 OR price > 900) AND purchase_date < '21-JAN-2001' ORDER BY purchase date DESC;

点击查看答案

第5题

[单选题] BookStore数据库中有图书表Book（BookCode，BookName，Author，PublisherCode，PublishTimePublishTime是datetime类型。显示图书的最高价、最低价、平均价、最高价与最低价之间的差值。SQL语句：SELECTMAX（Price）As最高价，MIN（Price）As最低价，Str（AVG（Price），6，2）As平均价（）As最高价与最低价的差值FromBook

A、（MAX-MIN）Price B、MAX（Price）-MIN（Price） C、（MAX-MIN）（Price） D、MAX：Price-MIN：Price

点击查看答案

第6题

[] You want to display the titles of books that meet these criteria: 1. Purchased before January 21, 2001 2. Price is less then $500 or greater than $900 You want to sort the results by their data of purchase, starting with the most recently bought book. Which statement should you use? （） You want to display the titles of books that meet these criteria: 1. Purchased before January 21, 2001 2. Price is less then $500 or greater than $900 You want to sort the results by their data of purchase, starting with the most recently bought book. Which statement should you use? （）

A、A. SELECT book_title FROM books WHERE price between 500 and 900 AND purchase_date < '21-JAN-2001' ORDER BY purchase_date; B、B. SELECT book_title FROM books WHERE price IN (500,900) AND purchase_date < '21-JAN-2001' ORDER BY purchase date ASC; C、C. SELECT book_title FROM books WHERE price < 500 or > 900 AND purchase_date < '21-JAN-2001' ORDER BY purchase date DESC; D、D. SELECT book_title FROM books WHERE (price < 500 OR price > 900) AND purchase_date < '21-JAN-2001' ORDER BY purchase date DESC;