下面关于“CREATE VIEW v_goods AS SELECT id, name FROM goods”描述错误的是
举一反三
- 下面正确表示查询goods表中type和name的SQL语句是。 A: select * from goods; B: select type name from goods; C: select type,name from goods; D: select name type from goods;
- 下面定义视图的SQL语句，哪一个是错误的？（ ） A: create view VIEW1 as select id,name,sex from users B: create view VIEW2 as select count(*) as studentTotal,classname from student C: create view VIEW3 as select name,price from D: create view VIEW4 as select logdate,price,1.1*parice as ‘涨价’ from shop
- 查询goods中所有记录。 A: select all from goods; B: select distinct from goods; C: select * from goods; D: select from goods;
- 查询数据表goods中的数据,命令是 A: select * from goods; B: select * from goods C: select * fromgoods; D: select from goods;
- 查询goods表中有几种类型的商品 A: select * from goods; B: select type from goods; C: select type distinct from goods; D: select distinct type from goods;