下列命令不能执行的是（）。
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
举一反三
- 查询数据表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;