下列命令不能执行的是（）。
A: SELECT*FROM[select]
B: SELECT*FROM@MyTable
C: SELECT*FROM[MyTable]
D: SELECT*FROMMyTable
A: SELECT*FROM[select]
B: SELECT*FROM@MyTable
C: SELECT*FROM[MyTable]
D: SELECT*FROMMyTable
B
举一反三
- 查询数据表goods中的数据,命令是 A: select * from goods; B: select * from goods C: select * fromgoods; D: select from goods;
- 下列的查询语句哪一项是错误的（选一项） A: Select * from stumarks where score>=60 B: Select * from (select * from stumarks where score>=60) C: Select * from (select * from stumarks where score>=60) as temp D: Select * from (select * from stumarks ) as temp where score>=60
- 下列（ ）语句不能实现分析查询语句。 A: DESCRIBE SELECT * FROM tb_bookinfo; B: EXPLAIN SELECT * FROM tb_bookinfo; C: SHOW SELECT * FROM tb_bookinfo; D: DESC SELECT * FROM tb_bookinfo;
- 查询goods中所有记录。 A: select all from goods; B: select distinct from goods; C: select * from goods; D: select from goods;
- 下面检索结果一定不是一行的命令： A: select distinct * from orders ; B: select * from orders limit 1，2; C: select top 1 * from orders; D: select * from orders limit 1;
内容
- 0
下列____是Select数据库查询语句中不可缺少的。 A: Select、From B: Select、Where C: From、Order By D: Select、All
- 1
以下语句哪个是正确的Select查询语句( ) A: select * from use B: select distinct username user; C: select * from user where ; D: select * from user username=’李四’;
- 2
以下语句不正确的是( ) A: select * from emp; B: select ename,hiredate,sal from emp; C: select * from emp order deptno; D: select * from where deptno=1
- 3
给定下列表： 下列哪一个语句会产生所需结果？（） A: SELECT UNIQUE * FROM tab1 B: SELECT DISTINCT * FROM tab1 C: SELECT UNIQUE（*） FROM tab1 D: SELECT DISTINCT（*） FROM tab1
- 4
select语句的完整语法较复杂，但至少包括的部分是（ ）。A. 仅selectB. select, from C. select, groupD. select,where A: 仅select B: select, from C: select, group D: select,where