皮皮学，免费搜题
登录
搜题
【多选题】
BookStore数据库中有图书表Book(BookCode, BookName, Author, PublisherCode, PublishTime ,BookSort, ISBN, BookPicture, ContentInro, Price, Discount),其中 PublishTime是datetime类型。 查询 2009 年出版的少儿类图书,要求显示图书名称( BookName )、作者( Author )、出版时间( PublishTime )、价格( Price )和折扣( Discount ),并且字段标题分别为图书名称、作者、内容简介、价格和折扣。 SQL 语句 : SELECT BookName 图书名称, Author 作者, convert(char(10), PublishTime, 120) 出版时间, Price 价格, Discount 折扣 FROM Book WHERE BookSort='少儿' AND _________A.
PublishTime=2009
B.
YEAR(PublishTime)=2009
C.
PublishTime>='2009-1-1' AND PublishTime
D.
PublishTime>='2009-1-1' AND PublishTime<='2009-12-31'< /div>
拍照语音搜题，微信中搜索"皮皮学"使用
参考答案：
参考解析：
知识点：
皮皮学刷刷变学霸
举一反三
【单选题】When Edison died, it was proposed that the American people all power in their homes, streets, and factories for several minutes in honour of this great man.
A.
turn off
B.
turned off
C.
would turn off
D.
had turned off
【判断题】如果字段“成绩”的取值范围为0~100,则0<=[成绩]<=100写法是正确的。< /div>
A.
正确
B.
错误
【简答题】Honors: A. The United States gave him its highest award, a special Congressional Medal of Honor. B. When Edison died, it was proposed that the American people _______ for several minutes in honor of t...
【单选题】如果字段“成绩”的取值范围为0-100,则正确的验证规则是()
A.
0-100
B.
[成绩]>=0 且 [成绩]<=100< /div>
【简答题】Task 4 Thomas Alva Edison was awarded more patents ( 专利 ) on inventions than any other American. When he died in 1931, Americans wondered how they could best show their respect for him. One suggestion...
【单选题】When Edison died, it was proposed that the American people ( ) all power in their homes, streets, and factories for several minutes in honor of this great man.
A.
turn off
B.
turned off
C.
would turn off
D.
had turned off
【简答题】. Thomas Alva Edison was awarded more patents on inventions than any other American. When he died in 1931, Americans wondered how they could best show their respect for him. One suggestion was that th...
【简答题】Thomas Alva Edison was awarded more patents on inventions than any other American. When he died in 1931, Americans wondered how they could best show their respect for him. One suggestion was that the ...
相关题目：
【判断题】如果字段“成绩”的取值范围为0~100,则0<=[成绩]<=100写法是正确的。< /div>
A.
正确
B.
错误
【单选题】如果字段“成绩”的取值范围为0-100,则正确的验证规则是()
A.
0-100
B.
[成绩]>=0 且 [成绩]<=100< /div>