题目
[主观题]
18、查询2009年出版的少儿类图书,要求显示图书名称(BookName)、作者(Author)、出版时间(PublishTime)、价格(Price)和折扣(Discount),并且字段标题分别为图书名称、作者、内容简介、价格和折扣。语句如下: SELECT BookName AS 图书名称, Author AS 作者, convert(char(10), PublishTime, 120) AS 出版时间, Price AS 价格, Discount AS 折扣 FROM Book WHERE ________=2009 AND BookSort='少儿'
答案
YEAR(PublishTime)=2009;PublishTime >= ' 2009 -1-1 ' AND PublishTime < '2010-1-1';PublishTime >= ' 2009 -1-1 ' AND PublishTime <= ' 2009 -12-31 '
更多“18、查询2009年出版的少儿类图书,要求显示图书名称(BookName)、作者(Author)、出版时间(PublishTime)、价格(Price)和折扣(Discount),并且字段标题分别为图…”相关的问题
第1题
查询2009年出版的少儿类图书,要求显示图书名称(BookName)、作者(Author)、出版时间(PublishTime)、价格(Price)和折扣(Discount),并且字段标题分别为图书名称、作者、内容简介、价格和折扣。语句如下: SELECT BookName AS 图书名称, Author AS 作者, convert(char(10), PublishTime, 120) AS 出版时间, Price AS 价格, Discount AS 折扣 FROM Book WHERE ________=2009 AND BookSort='少儿'
点击查看答案
第2题
查询2009年出版的少儿类图书,要求显示图书名称(BookName)、作者(Author)、出版时间(PublishTime)、价格(Price)和折扣(Discount),并且字段标题分别为图书名称、作者、内容简介、价格和折扣。语句如下: SELECT BookName AS 图书名称, Author AS 作者, convert(char(10), PublishTime, 120) AS 出版时间, Price AS 价格, Discount AS 折扣 FROM Book WHERE ________=2009 AND BookSort='少儿'
点击查看答案
第3题
BookStore数据库中有图书表Book(BookCode, BookName, Author, PublisherCode, PublishTime,BookSort, ISBN, BookPicture, ContentInro, Price, Discount),其中 PublishTime是datetime类型。 查询2009年出版的少儿类图书,要求显示图书名称(BookName)、作者(Author)、出版时间(PublishTime)、价格(Price)和折扣(Discount),并且字段标题分别为图书名称、作者、内容简介、价格和折扣。SQL语句: SELECT BookName As 图书名称, Author As 作者, convert(char(10), PublishTime, 120) As 出版时间, Price As 价格, Discount As 折扣 FROM Book WHERE BookSort='少儿' AND _________
A.PublishTime=2009
B.YEAR(PublishTime)=2009
C.PublishTime>='2009-1-1' AND PublishTime<'2010-1-1'
D.PublishTime>='2009-1-1' AND PublishTime<='2009-12-31'
点击查看答案
第4题
BookStore数据库中有图书表Book(BookCode, BookName, Author, PublisherCode, PublishTime,BookSort, ISBN, BookPicture, ContentInro, Price, Discount),其中 PublishTime是datetime类型。 查询2009年出版的少儿类图书,要求显示图书名称(BookName)、作者(Author)、出版时间(PublishTime)、价格(Price)和折扣(Discount),并且字段标题分别为图书名称、作者、内容简介、价格和折扣。SQL语句: SELECT BookName As 图书名称, Author As 作者, convert(char(10), PublishTime, 120) As 出版时间, Price As 价格, Discount As 折扣 FROM Book WHERE BookSort='少儿' AND _________
A.PublishTime=2009
B.YEAR(PublishTime)=2009
C.PublishTime>='2009-1-1' AND PublishTime<'2010-1-1'
D.PublishTime>='2009-1-1' AND PublishTime<='2009-12-31'
点击查看答案
第5题
查询作者名长度大于等于8的图书信息,显示书名(BookName)及作者(Author)。语句如下: SELECT BookName, Author FROM Book WHERE Len(Author)_________
点击查看答案
第6题
BookStore数据库中有图书表 Book(BookCode, BookName, Author, PublisherCode, PublishTime,BookSort, ISBN, BookPicture, ContentInro, Price, Discount) 查询作者名长度大于等于8的图书信息,显示书名(BookName)及作者(Author)。SQL语句: SELECT BookName, Author FROM Book WHERE Lenth(Author)= 8
点击查看答案
第7题
【判断题】BookStore数据库中有图书表 Book(BookCode, BookName, Author, PublisherCode, PublishTime,BookSort, ISBN, BookPicture, ContentInro, Price, Discount) 查询作者名长度大于等于8的图书信息,显示书名(BookName)及作者(Author)。SQL语句: SELECT BookName, Author FROM Book WHERE Lenth(Author)= 8
点击查看答案