Can somebody give the SQL Query to same list price product?
Question: 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.
Note: Use a self-join to find that the ProductID columns are not equal but the ListPrice column is equal. Sort the result set by ProductName.