You have a database that contains the tables as shown in the exhibit. You need to create a query
that returns a list of products from Sales.ProductCatalog. The solution must meet the following
requirements:
– UnitPrice must be returned in descending order.
– The query must use two-part names to reference the table.
– The query must use the RANK function to calculate the results.
– The query must return the ranking of rows in a column named PriceRank.
– The list must display the columns in the order that they are defined in
the table.
– PriceRank must appear last.
Which code segment should you use? To answer, type the correct code in the answer area.
Answer: See the explanation
Explanation:
SELECT ProductCatalog.CatID, ProductCatalog.CatName,
ProductCatalog.ProductID, ProductCatalog.ProdName,
ProductCatalog.UnitPrice,
RANK() OVER (PARTITION BY ProductCatalog.UnitPrice) AS PriceRank
FROM Sales.ProductCatalog
ORDER BY ProductCatalog.UnitPrice DESC
Answer should be:
SELECT ProductCatalog.CatID, ProductCatalog.CatName, ProductCatalog.ProductID, ProductCatalog.ProdName, ProductCatalog.UnitPrice
RANK() OVER (ORDER BY ProductCatalog.UnitPrice DESC) AS PriceRank
FROM Sales.ProductCatalog
ORDER BY ProductCatalog.UnitPrice DESC
1
0
select cartid, cartname, productid, prodname, unitprice,
rank() over (order by unitprice desc) pricerank
from sales.productcatalog
order by pricerank
0
0