• 2021-04-14
    BookStore数据库中有客户表Customer(CustomerCode, Name, Sex, Hometown, Email, Telephone, LoginDate, Password)


    查询Customer表中所有客户的信息,SQL语句:


    SELECT ________ FROM Customer
  • CustomerCode, Name, Hometown, Sex, Email, Telephone, LoginTime, PassWord --- CustomerCode, Hometown, Telephone, Name, Sex, Email, LoginTime, PassWord --- *

    内容

    • 0

      假设需要从CUSTOMER客户表中检索数据,可以使用如下()语句。 A: SELECT*FROMCUSTOMER B: SELECT*CUSTOMER C: MODIFY*FROMCUSTOMER D: UPDATE*FROMCUSTOMER

    • 1

      BookStore数据库中有客户评价表CustomerEvaluation(CustomerCode, VIPClass, Author, EvaluateDate),其中 PublishTime是datetime类型。 查询用户等级(VIPClass)为“A”的客户编号(CustomerCode)和评价时间(EvaluateDate),要求显示标题分别为“客户编号”和“评价时间”。SQL语句: SELECT CustomerCode As 客户编号, EvaluateDate As 评价时间 FROM CustomerEvaluation WHERE _________

    • 2

      数据库中有一张表名称为Student,有列Name,Age,IDCard,Sex。要求查询所有男同学信息,下列哪个SQL语句是正确的 A: Select * From Student Where Sex '男' B: Select * From Student Where Sex ='女' C: Select * From Student Where Sex In '男' D: Select * From Student Where Sex ='男'

    • 3

      BookStore数据库中有出版社表Publisher(PublisherCode,Publisher,Telephone)将Publisher表中出版社代号(CustomerCode)为“01”的出版社联系电话(Telephone)修改为“010-”。SQL语句:________。

    • 4

      中国大学MOOC: BookStore数据库关系图如下:http://nos.netease.com/edu-image/a19baff5-f75d-4c39-95df-e2264342b520.png查询所有客户的购书情况(也包括未购书人的信息),显示客户号(CustomerCode)、客户名(Name)和订单号(OrderCode)、购书时间(OrderTime)。SQL语句:SELECT Customer.CustomerCode, Name, OrderCode, OrderTimeFROM ________ ON Customer.CustomerCode=[Order].CustomerCode