知识检查

1.

编写 Transact-SQL 查询来列出产品的可用大小。每个单独的大小应该只列出一次。该使用哪个查询？

SELECT Size FROM Production.Product;

SELECT DISTINCT Size FROM Production.Product;

SELECT ALL Size FROM Production.Product;

2.

必须按 TotalDue 值的降序从 Sales.Invoice 表返回 InvoiceNo 和 TotalDue 列。该使用哪个查询？

SELECT * FROM Sales.Invoice ORDER BY TotalDue, InvoiceNo;

SELECT InvoiceNo, TotalDue FROM Sales.Invoice ORDER BY TotalDue DESC;

SELECT TotalDue AS DESC, InvoiceNo FROM Sales.Invoice;

3.

要成此查询以仅返回类别值为 2 或 4 的产品：SELECT Name, Price FROM Production.Product 应添加哪个子句？

ORDER BY Category;

WHERE Category BETWEEN 2 AND 4;

WHERE Category IN (2, 4);

反馈