Question

In SQL Use AdventureWorksDW2014

-- 7. List the product alternate key, product name, and list price for the product(s)
-- with the highest List Price. There can be multiple products with the highest list price.
-- Sort by Product Alternate Key ascending.
-- I got 5 rows.

Answer 1

To list the product alternate key, product name, and list price for the product(s) with the highest list price in SQL, you can use the AdventureWorksDW2014 database. Use the MAX function with the WHERE clause to filter for the highest list price, and the ORDER BY clause to sort the results by the product's alternate key in ascending order.

Step-by-step explanation:

To list the product alternate key, product name, and list price for the product(s) with the highest list price in SQL, you can use the AdventureWorksDW2014 database. To sort the results by Product Alternate Key ascending, you can use the ORDER BY clause. Here is an example query:

SELECT ProductAlternateKey, ProductName, ListPrice FROM [AdventureWorksDW2014].[dbo].[DimProduct] WHERE ListPrice = (SELECT MAX(ListPrice) FROM [AdventureWorksDW2014].[dbo].[DimProduct]) ORDER BY ProductAlternateKey ASC;

This query will return the product(s) with the highest list price, sorted by their alternate key in ascending order. It should give you 5 rows of results.