问答题

查询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)或YEAR(PublishTime)或YEAR(PublishTime)或Year(p...
微信扫码免费搜题