- 搜标题
- 搜题干
- 搜选项
单项选择题
如果一张表的结构为Products（ID，Name，UnitsInStock），可以查询出所有尚有库存的Coffee类产品的 SQL 是：
A、SELECT * FROM Products WHERE Name = ‘%Coffee%’ and UnitsInStock>0
B、SELECT Name FROM Products WHERE Name = ‘_Coffee_’ and UnitsInStock!=0
C、SELECT * FROM Products WHERE Name Like ‘%Coffee%’ and UnitsInStock>0
D、SELECT Name FROM Products WHERE Name Like ‘_Coffee_’ and UnitsInStock!=0
B、SELECT Name FROM Products WHERE Name = ‘_Coffee_’ and UnitsInStock!=0
C、SELECT * FROM Products WHERE Name Like ‘%Coffee%’ and UnitsInStock>0
D、SELECT Name FROM Products WHERE Name Like ‘_Coffee_’ and UnitsInStock!=0
你可能感兴趣的试题
