下列不能为查询列指定别名的语句是
A: select g_ID=商品号 from Goods
B: select g_ID 商品号 from Goods
C: select g_ID AS 商品号 from Goods
D: select 商品号=g_ID from Goods
A: select g_ID=商品号 from Goods
B: select g_ID 商品号 from Goods
C: select g_ID AS 商品号 from Goods
D: select 商品号=g_ID from Goods
举一反三
- 删除Goods表中，g_ID='040002'的商品信息语句是_______ from Goods where g_ID='040002'
- 智慧职教: 查看商品表，比较 SELECT * FROM goods； 和 SELECT * FROM goods G； 你认为G的作用是？
- 查询goods表中有几种类型的商品 A: select * from goods; B: select type from goods; C: select type distinct from goods; D: select distinct type from goods;
- 要查询Goods表中商品中含有“电冰箱”的商品情况，可用（ ） A: SELECT * FROM Goods WHERE g_Name LIKE '电冰箱%' B: SELECT * FROM Goods WHERE g_Name LIKE '电冰箱_' C: SELECT * FROM Goods WHERE g_Name LIKE '%电冰箱%' D: SELECT * FROM Goods WHERE g_Name='电冰箱'
- 查询goods中所有记录。 A: select all from goods; B: select distinct from goods; C: select * from goods; D: select from goods;