皮皮学，免费搜题
登录
搜题
【简答题】
Who was Miss Fanny Jackson? [ A] The only daughter of General ' Stone Wall' Jackson. [ B ] A little known girl who sold her father' s letters to Robert Spring. [ C] Robert Spring' s daughter. [ D ] An imaginary person created by Spring.
拍照语音搜题，微信中搜索"皮皮学"使用
参考答案：
参考解析：
知识点：
皮皮学刷刷变学霸
举一反三
【简答题】我们还可以在一个语句中完成创建表并且将查询结果装载到这个表中。 【示例】 create table test_new as select name ,age from fq1 em where em.dt=’2019-03-11’ 从上面的案例中可以看到,新创建的这张表test_new只含有fq1表中的dt为‘2019-03-11’的name,age两个字段的信息。新表的模式是根据SELECT语句...
【单选题】公司有一个客户的数据表,此表的建立语句如下: CREATE TABLE Customers (CustomerID int NOT NULL, CustomerName varchar(50) NOT NULL, ContactName varchar(30) NULL, Phone varchar(20) NULL, Country varchar(30) NOT NULL, CONSTRAIN...
A.
SELECT Country FROM Customers GROUP BY Country HAVING COUNT (Country)>=10
B.
SELECT TOP 10 Country FROM Customers
C.
SELECT TOP 10 Country FROM Customers FROM (SELECT DISTINCT Country FROM Customers) AS X GROUP BY Country HAVING COUNT(*)>= 10
D.
SET ROWCOUNT 10 SELECT Country, COUNT (*) as “NumCountries” FROM Customers GROUP BY Country ORDER BY NumCountries, Desc
【单选题】只把学生表student的结构复制为新表newStudent，下面正确的语句是______。
A.
CREATE TABLE newStudent AS SELECT * FROM student
B.
CREATE TABLE newStudent AS SELECT * FROM student LIMIT 0
C.
CREATE TABLE newStudent AS SELECT * FROM student LIMIT 0, 1
D.
CREATE TABLE newStudent AS SELECT * FROM student LIMIT 1, 1
【单选题】已知关系模式：图书（图书编号，图书类型，图书名称，作者，出版社，出版日期，ISBN），图书编号唯一识别一本图书。建立“计算机”类图书的视图Computer-BOOK，并要求进行修改、插入操作时保证该视图只有计算机类的图书。实现上述要求的SQL语句如下： CREATE （56）。 AS SELECT图书编号，图书名称，作者，出版社，出版日期 FROM图书 WHERE图书类型=＇计算机＇ with c...
A.
TABLE Computer-BOOK
B.
VIEWComputer-BOOK
C.
Computer-BOOK TABLE
D.
Computer-BOOKVIEW
相关题目：