单项选择题
A.INSERT INTO Publisher VALUES(‘群众出版社’,’66’,’0321-76584391’)
B.INSERT INTO Publisher VALUES(‘群众出版社‘,66,’0321-76584391’)
C.INSERT INTO Publisher VALUES(‘66’,’群众出版社‘,’0321-76584391’)
D.INSERT Publisher VALUES(‘66’,’群众出版社‘,’0321-76584391’)
判断题 BookStore数据库中有图书表Book(BookCode,BookName,Author,PublisherCode,PublishTime查询作者名长度大于等于8的图书信息,显示书名(BookName)及作者(Author)。SQL语句:SELECTBookName,AuthorFROMBookWHERELenth(Author)=8
判断题 BookStore数据库中有图书表Book(BookCode,BookName,Author,PublisherCode,PublishTime查询图书名称(BookName)含有“程序”的图书信息。SQL语句:SELECTBookCode,BookName,Author,Price,DiscountFROMBookWHEREName=“%程序%”
多项选择题 BookStore数据库中有订单表Order(OrderCode,CustomerCode,TotalPrice,Address,OrderTime,OrderStatus)查询订单总价(TotalPrice)在100到200元之间的订单信息。SQL语句:SELECTOrderCode,TotalPrice,OrderTime,OrderStatus FROM[Order]WHERE()