BookStore数据库中有客户表Customer(CustomerCode,Name,Sex,Hometown,Email,Telephone,LoginDate,Password)查询Customer表中所有客户的信息,SQL语句:SELECT________FROMCustomer
BookStore数据库中有客户表Customer(CustomerCode,Name,Sex,Hometown,Email,Telephone,LoginDate,Password)查询Customer表中所有客户的信息,SQL语句:SELECT________FROMCustomer
A.*
B.CustomerCode,Name,Hometown,Sex,Email,Telephone,LoginTime,PassWord
C.CustomerCode,Hometown,Telephone,Name,Sex,Email,LoginTime,PassWord
D.CustomerCode~PassWord
正确答案:ABC
Tag:信息系统与数据库技术 客户 语句
时间:2021-03-08 16:01:52
- 上一篇:BookStore数据库中有销售明细表OrderDetail(OrderCode,BookCode,Amount)查询销售总量前20%的图书,并按总销量降序排列。SQL语句:SELECTTOP20PERCENTBookcodeAs书号,SUM(Amount)As总销量ROMOrderDetailGROUPBYBookcodeORDERBY________
- 下一篇:BookStore数据库中有订单表Order(OrderCode,CustomerCode,TotalPrice,Address,OrderTime,OrderStatus)查询订单总价(TotalPrice)在100到200元之间的订单信息。SQL语句:SELECTOrderCode,TotalPrice,OrderTime,OrderStatusFROM[Order]WHERE________