Monday, February 23, 2015

#15. Write a SELECT statement that returns the ProductName and ListPrice columns from the Products table.

#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.


No comments:

Post a Comment