多选题BookStore数据库中有图书Book(BookCode,BookName,Author,PublisherCode,PublishTimePublishTime是datetime类型。查询2009年出版的少儿类图书,要求显示图书名称(BookName)、作者(Author)、出版时间(PublishTime)、价格(Price)和折扣(Discount),并且字段标题分别为图书名称、作者、内容简介、价格和折扣。SQL语句SELECTBookNameAs图书名称,AuthorAs作者,convert(char(10),PublishTime,120)As出版时间,PriceAs价格,DiscountAs折扣FROMBookWHEREBookSort=‘少儿’AND()APublishTime=2009BYEAR(PublishTime)=2009CPublishTime=‘2009-1-1‘ANDPublishTime‘2010-1-1’DPublishTime=‘2009-1-1‘ANDPublishTime=‘2009-12-31‘

多选题
BookStore数据库中有图书Book(BookCode,BookName,Author,PublisherCode,PublishTimePublishTime是datetime类型。查询2009年出版的少儿类图书,要求显示图书名称(BookName)、作者(Author)、出版时间(PublishTime)、价格(Price)和折扣(Discount),并且字段标题分别为图书名称、作者、内容简介、价格和折扣。SQL语句SELECTBookNameAs图书名称,AuthorAs作者,convert(char(10),PublishTime,120)As出版时间,PriceAs价格,DiscountAs折扣FROMBookWHEREBookSort=‘少儿’AND()
A

PublishTime=2009

B

YEAR(PublishTime)=2009

C

PublishTime>=‘2009-1-1‘ANDPublishTime<‘2010-1-1’

D

PublishTime>=‘2009-1-1‘ANDPublishTime<=‘2009-12-31‘


参考解析

解析: 暂无解析

相关考题:

● 在XML中,元素book 的声明语句如下:!ELEMENT book (title,price+,author?,borrow*)该声明语句表明,元素book中子元素 (62) 至少出现一次。A. title B. price C. author D. borrow

在考生文件夹下完成下列基本操作:(1)新建一个名为“图书管理”的项目。(2)在项目中建立一个名为“图书”的数据库。(3)将考生文件夹下的所有自由表添加到“图书”数据库中。(4)在项目中建立查询book_ qu,查询价格大于等于10的图书(book 表)的所有信息,查询结果按“价格”降序排序。

在“BOOK.mdb”数据库中有Book、等级、读者、借阅和未借图书五张表。(1) 以等级和读者表为数据源创建“读者信息”查询,结果显示读者姓名、等级名称和可借数量字段。查询结果如图所示。(2) 以book表为数据源,创建追加查询“未借图书查询”,将未借图书的全部信息追加到未借图书表中。

在“BOOK.mdb”数据库中有Book、等级、读者、借阅和未借图书五张表。(1)以book表和借阅表为数据源,创建“查询2”,统计高等教育出版社图书已借出情况。结果显示出版社和共借出([借阅].[书 ID]之Count)字段。查询结果如图所示。(2)创建宏“宏1”,运行“借阅情况”查询。

talbe :pub(pub_code char(2),pub_name varchar2(32))book(book_code char(8),book_name varhcar2(128),pub_code char92),author_codechar(4),book_mem varchar2(128))author(author_code char(4),author_name varchar2(10),sex char(1), agenumber(3),dir varchar2(64))auth_list(auth_date date,author_code char(4))在PL/SQL中有以下两种字义v_book_row book%rowtype;v_book_code book.bank_code%type;请说明v_book_row,v_book_code变量的含义以及数据类型

要查询book表中所有书名以“电子商务”开头的书籍作者,可用(61)语句。A.SELECT author FROM booK WHERE book _name=‘电子商务*’B.SELECT author FROM booK WHERE book _name LIKE‘电子商务*’C.SELECT author FROM booK WHERE book_ name=‘电子商务%’D.SELECT author FROM booK WHERE book_name LIKE‘电子商务%’

阅读下面XML文档,下列说法正确的是(64)。 <book <authortony</author<!--作者信息 - <bookcode97873022</bookcode </bookA.<book是元素对象,同样也是数据内容B.<author是数据内容C.<!一,作者信息-是元素对象D.97873022是数据内容

阅读下面XML文档,下列说法正确的是______。<book><author>tony</author><!--作者信息--><bookcode>97873022</book>A.<book>是元素对象,同样也是数据内容B.<author>是数据内容C.<!--作者信息-->是元素对象D.97873022是数据内容

BookStore数据库中有图书表Book(BookCode,BookName,Author,PublisherCode,PublishTime查询作者名长度大于等于8的图书信息,显示书名(BookName)及作者(Author)。SQL语句:SELECTBookName,AuthorFROMBookWHERELenth(Author)=8

阅读下面XML文档,然后判断下列说法正确的是()。 <book> <author>tom</author> <bookcode12</bookcode> </book>A、<book>是元素对象,同样也是文本对象B、<author>是元素对象,同样也是文本对象C、tom是文本对象D、tom是元素对象

BookStore数据库中有图书表Book(BookCode,BookName,Author,PublisherCode,PublishTime,PublishTime是datetime类型。查询Book表中的图书类别(BookSort),要求每个类别只显示一次。SQL语句:SELECT()BookSort FROM BookA、DISTINCTB、ONLYC、ONED、PERCENT

BookStore数据库中有销售明细表OrderDetail(OrderCode,BookCode,Amount)查询销售总量前20%的图书,并按总销量降序排列。SQL语句:SELECT TOP 20 PERCENT Bookcode As书号,SUM(Amount)As总销量ROMOrderDetail GROUP BY Book code ORDER BY()A、AmountDESCB、SUM(Amount)DESCC、COUNT(Amount)DESCD、ADD(Amount)DESC

BookStore数据库中有图书表Book(BookCode,BookName,Author,PublisherCode,PublishTimePublishTime是datetime类型。显示图书的最高价、最低价、平均价、最高价与最低价之间的差值。SQL语句:SELECTMAX(Price)As最高价,MIN(Price)As最低价,Str(AVG(Price),6,2)As平均价()As最高价与最低价的差值FromBookA、(MAX-MIN)PriceB、MAX(Price)-MIN(Price)C、(MAX-MIN)(Price)D、MAX:Price-MIN:Price

BookStore数据库中有客户评价表CustomerEvaluation(CustomerCode,VIPClass,Author,EvaluateDate),其中PublishTime是datetime类型。查询用户等级(VIPClass)为“A”的客户编号(CustomerCode)和评价时间(EvaluateDate),要求显示标题分别为“客户编号”和“评价时间”。SQL语句:SELECT Customer CodeAs客户编号,Evaluate DateAs评价时间FROM Customer Evaluation WHERE()A、VIPClass=‘A’B、VIPClass=”A”C、VIPClass=AD、VIPClass==A

BookStore数据库中有图书Book(BookCode,BookName,Author,PublisherCode,PublishTimePublishTime是datetime类型。查询2009年出版的少儿类图书,要求显示图书名称(BookName)、作者(Author)、出版时间(PublishTime)、价格(Price)和折扣(Discount),并且字段标题分别为图书名称、作者、内容简介、价格和折扣。SQL语句SELECTBookNameAs图书名称,AuthorAs作者,convert(char(10),PublishTime,120)As出版时间,PriceAs价格,DiscountAs折扣FROMBookWHEREBookSort=‘少儿’AND()A、PublishTime=2009B、YEAR(PublishTime)=2009C、PublishTime=‘2009-1-1‘ANDPublishTime‘2010-1-1’D、PublishTime=‘2009-1-1‘ANDPublishTime=‘2009-12-31‘

BookStore数据库中有图书表Book(BookCode,BookName,Author,PublisherCode,PublishTime查询图书名称(BookName)含有“程序”的图书信息。SQL语句:SELECTBookCode,BookName,Author,Price,DiscountFROMBookWHEREName=“%程序%”

如果要查询book表中所有书名以“数据库”开头的书籍价格,下列()语句是正确的。A、SELECT price FROM book WHERE book_name=“数据库*”B、SELECT price FROM book WHERE book_name LIKE“数据库*”C、SELECT price FROM book WHERE book_name=“数据库%”D、SELECT price FROM book WHERE book_name LIKE“数据库%”

关于SQL语句“SELECTAuthor,BookName,ID,ISBN,Price FROM book ORDER BY ID DESC”的说法错误的是()。A、该语句表示从表“book”中查询所有记录B、该语句显示的字段是“Author”、“BookName”、“ID”、“ISBN”和“Price”C、该语句对查询到的记录将根据ID按升序排列D、该语句中的“book”表示数据表

单选题Some readers think the words in the author’s book is too _____.AdepressingBfrighteningCdelightingDidealistic

单选题BookStore数据库中有图书表Book(BookCode,BookName,Author,PublisherCode,PublishTime,PublishTime是datetime类型。查询Book表中的图书类别(BookSort),要求每个类别只显示一次。SQL语句:SELECT()BookSort FROM BookADISTINCTBONLYCONEDPERCENT

判断题BookStore数据库中有图书表Book(BookCode,BookName,Author,PublisherCode,PublishTime查询作者名长度大于等于8的图书信息,显示书名(BookName)及作者(Author)。SQL语句:SELECTBookName,AuthorFROMBookWHERELenth(Author)=8A对B错

单选题The reviewer didn’t make notes in the margin of the book becauseAit was not convenient on the plane.Bthe author of the book had made them.Che borrowed the book from others.

多选题BookStore数据库中有图书表Book(BookCode,BookName,Author,PublisherCode,PublishTimePublishTime是datetime类型。将Book表中的所有“外语”类图书的价格降低10%,并将折扣均设为8折。SQL语句:UPDATEBookSET()WhereBookSort=‘外语‘。APrice=Price*0.9,Discount=0.8BPrice=Price*(1-10%),Discount=0.8CPrice=0.9,Discount=0.8DDiscount=0.8,Price=Price*0.9

判断题BookStore数据库中有图书表Book(BookCode,BookName,Author,PublisherCode,PublishTime查询图书名称(BookName)含有“程序”的图书信息。SQL语句:SELECTBookCode,BookName,Author,Price,DiscountFROMBookWHEREName=“%程序%”A对B错

多选题BookStore数据库中有销售明细表OrderDetail(OrderCode,BookCode,Amount)在OrderDetail表中添加一条记录:“08110801”、0701、3。SQL语句:()AINSERT INTOOrderDetail(OrderCode,Amount,BookCode)VALUES(‘08110801’,3,’0701’)BINSERT INTOOrderDetail(OrderCode,Amount,BookCode)VALUES(‘08110801’,’0701’,3)CINSERT INTOOrderDetail(OrderCode,BookCode,Amount)VALUES(‘08110801’,’0701’,3)DINSERT INTOOrderDetailVALUES(‘08110801’,’0701’,3)

单选题Which of the following is the best version of sentence 1 (reproduced below)?Mike Reynolds who is the author of the book, The New Girl came to our school to speak about his book, which tells about him portraying a woman for six weeks.A(As it is now)BMike Reynolds, the author of The New Girl, spoke at our school about his book, in which he describes how he portrayed a woman for six weeks.CMike Reynolds, the author of The New Girl, came to our school and told us about his book, where he portrayed a woman for six weeks.DThe author of The New Girl, Mike Reynolds came to our school to speak, in it he portrayed a woman for six weeks,EThe author of The New Girl, Mike Reynolds, spoke at our school about his book, that portrays a woman for six weeks.

单选题关于SQL语句“SELECTAuthor,BookName,ID,ISBN,Price FROM book ORDER BY ID DESC”的说法错误的是()。A该语句表示从表“book”中查询所有记录B该语句显示的字段是“Author”、“BookName”、“ID”、“ISBN”和“Price”C该语句对查询到的记录将根据ID按升序排列D该语句中的“book”表示数据表

单选题BookStore数据库中有出版社表将Publisher表中出版社代号(CustomerCode)为“01”的出版社联系电话(Telephone)修改为“010-79797979”。SQL语句:()AUPDATE PublisherSET Telephone=010-79797979 WHERE PublisherCode=01BUPDATE PublisherSET Telephone=‘010-79797979’ WHERE PublisherCode=‘01’CUPDATE FROMPublisher SET Telephone=‘010-79797979’ WHERE PublisherCode=‘01’DUPDATE Publisher Telephone=‘010-79797979’ WHERE PublisherCode=‘01