将查询结果插入到一个新的局部临时表中的正确语句是( )。
A: select ...into
B: t from ...
C: select into
D: t ... from ...
E: select ...from ...into
F: t ...
G: select into
H: t ... from ...
A: select ...into
B: t from ...
C: select into
D: t ... from ...
E: select ...from ...into
F: t ...
G: select into
H: t ... from ...
举一反三
- 将查询结果插入到一个新的局部临时表中的正确语句是( )。 A: select ...into B: t from ... C: select into D: t ... from ... E: select ...from ...into F: t ... G: select into H: t ... from ...
- create table t（id int not null, a int default 0, b int default 0, c int default 0, primary key（id）, key idx_a_b（a, b））;下面语句能够利用到索引的是（） A: select b from t where a=10; B: select * from t where a=10 and id=100; C: select * from t where a=10 and b＞100; D: select * from t where a＞10 and b ＜ 100; E: select * from t order by b limit 10;
- 正确的生成表查询SQL语句是（）。 A: Select*into新表from数据源表 B: Select*set新表from数据源表 C: Select*from数据源表into新表 D: Select*from数据源表set新表
- 查询被借阅过的图书,语句SELECT name from book where____的条件,下列哪一个不能实现。 A: bno =all (select bno from borrow) B: bno =any (select bno from borrow) C: bno in (select bno from borrow) D: exists t(select * from borrow where bno=book.bno)
- 要查询学生表的所有内容的正确语句是 A: select ? from 学生表 B: select * from 学生表 C: select % from 学生表 D: select all from 学生表