#15. Write a SELECT statement that returns the ProductName and ListPrice columns from the Products table.
Return one row for each product that has the same list price as another product. Hint: Use a self-join to check that the ProductID columns aren’t equal but the ListPrice column is equal.
Sort the result set by ProductName.
Return one row for each product that has the same list price as another product. Hint: Use a self-join to check that the ProductID columns aren’t equal but the ListPrice column is equal.
Sort the result set by ProductName.
No comments:
Post a Comment