多项选择题
A.* B.CustomerCode,Name,Hometown,Sex,Email,Telephone,LoginTime,PassWord C.CustomerCode,Hometown,Telephone,Name,Sex,Email,LoginTime,PassWord D.CustomerCode~PassWord
BookStore数据库中有销售明细表OrderDetail(OrderCode,BookCode,Amoun...
单项选择题BookStore数据库中有销售明细表OrderDetail(OrderCode,BookCode,Amount)查询销售总量前20%的图书,并按总销量降序排列。SQL语句:SELECT TOP 20 PERCENT Bookcode As书号,SUM(Amount)As总销量ROMOrderDetail GROUP BY Book code ORDER BY()
A.AmountDESC B.SUM(Amount)DESC C.COUNT(Amount)DESC D.ADD(Amount)DESC
BookStore数据库中有图书表Book(BookCode,BookName,Author,Publishe...
单项选择题BookStore数据库中有图书表Book(BookCode,BookName,Author,PublisherCode,PublishTimePublishTime是datetime类型。显示图书的最高价、最低价、平均价、最高价与最低价之间的差值。SQL语句:SELECTMAX(Price)As最高价,MIN(Price)As最低价,Str(AVG(Price),6,2)As平均价()As最高价与最低价的差值FromBook
A.(MAX-MIN)Price B.MAX(Price)-MIN(Price) C.(MAX-MIN)(Price) D.MAX:Price-MIN:Price
BookStore数据库中有订单表Order(OrderCode,CustomerCode,TotalPric...
单项选择题BookStore数据库中有订单表Order(OrderCode,CustomerCode,TotalPrice,Address,OrderTime,OrderStatus)SELECTTOP3OrderCode,OrderTime,OrderStatusFROM[Order]语句中TOP3的含义是()
A.前3个字段 B.前3条属性 C.前3个记录 D.前3个别名