BookStore数据库中有客户表Customer(CustomerCode, Name, Sex, Hometown, Email, Telephone, LoginDate, Password)
查询Customer表中所有客户的信息,SQL语句:
SELECT ________ FROM Customer
查询Customer表中所有客户的信息,SQL语句:
SELECT ________ FROM Customer
举一反三
- BookStore数据库中有客户表Customer(CustomerCode, Name, Sex, Hometown, Email, Telephone, LoginDate, Password) 查询Customer表中所有客户的信息,要求显示CustomerCode、Name、Hometown和Telephone字段信息。SQL语句: SELECT _________ FROM Customer
- BookStore数据库中有客户表Customer(CustomerCode, Name, Sex, Hometown, Email, Telephone, LoginDate, Password) 删除Customer表中姓“刘”和姓“杨”的记录。SQL语句
- 查询Customer表中所有客户的信息,要求显示CustomerCode、Name、Hometown和Telephone字段信息。语句如下:SELECT _________ FROM Customer
- BookStore数据库中有客户表Customer(CustomerCode, ...______ FROM Customer
- BookStore数据库关系图如下: 查询所有客户的用户等级(VIPClass),要求显示客户号(CustomerCode)、客户名(Name)、用户等级(VIPClass)和评价时间(EvaluateDate)。SQL语句: SELECT Customer.CustomerCode, Name, VIPClass, EvaluateDate FROM Customer JOIN CustomerEvaluation ON _________93d78f5f684a42f403b7a3cf4cbc98a8.GIF