BookStore数据库中有图书表Book(BookCode,BookName,Author,PublisherCode,PublishTimePublishTime是datetime类型。将Book表中的所有“外语”类图书的价格降低10%,并将折扣均设为8折。SQL语句:UPDATEBookSET()WhereBookSort=‘外语‘。A、Price=Price*0.9,Discount=0.8B、Price=Price*(1-10%),Discount=0.8C、Price=0.9,Discount
题目内容(请给出正确答案)
BookStore数据库中有图书表Book(BookCode,BookName,Author,PublisherCode,PublishTimePublishTime是datetime类型。将Book表中的所有“外语”类图书的价格降低10%,并将折扣均设为8折。SQL语句:UPDATEBookSET()WhereBookSort=‘外语‘。
- A、Price=Price*0.9,Discount=0.8
- B、Price=Price*(1-10%),Discount=0.8
- C、Price=0.9,Discount=0.8
- D、Discount=0.8,Price=Price*0.9