下列（ ）语句不能实现分析查询语句。
A: DESCRIBE SELECT * FROM tb_bookinfo;
B: EXPLAIN SELECT * FROM tb_bookinfo;
C: SHOW SELECT * FROM tb_bookinfo;
D: DESC SELECT * FROM tb_bookinfo;
A: DESCRIBE SELECT * FROM tb_bookinfo;
B: EXPLAIN SELECT * FROM tb_bookinfo;
C: SHOW SELECT * FROM tb_bookinfo;
D: DESC SELECT * FROM tb_bookinfo;
举一反三
- 【单选题】统计图书信息表中每个出版社图书的平均价格。能得到正确结果的SELECT语句是 A: A、select pubname,AVG(price) from bookinfo order by puname B: select pubname,AVG(price) from bookinfo group by pubname C: select pubname,price from bookinfo D: select pubname,AVG(price) from bookinfo
- 【单选题】显示图书信息表中不同书架图书的平均价格大于50元的书架号和平均价格。能得到正确结果的SELECT语句是 A: select casename,AVG(price) <br> from bookinfo group by casename where AVG(price)>50 B: select casename,AVG(price)>50 from bookinfo group by casename C: select casename,AVG(price) <br> from bookinfo<br> having AVG(price)>50 group by casename D: select casename,AVG(price) <br> from bookinfo group by casename<br> having AVG(price)>50
- 【单选题】设有表TA(a,b,c)和表TB(c,d),其中字段c为关联两表的同名公共字段。 欲查询两表中的所有记录,正确的SQL语句是()。 A. Select * From TA,TB B. Select a,b,c,d From TA,TB; Where TA.c=TB.c C. Select TA.a,TA.b,TA.c,TB.d From TA,TB: Inner Join TA.c=TB.c D. Select a,b,TA.c,d From TA,TB; Where TA.c=TB.c
- 以下语句哪个是正确的Select查询语句( ) A: select * from use B: select distinct username user; C: select * from user where ; D: select * from user username=’李四’;
- 下列的查询语句哪一项是错误的（选一项） 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