Reshma Thomas

Reshma Thomas

  • NA
  • 3
  • 826

plz answer to this query

Nov 12 2015 1:46 PM
Write a query to display customer name & rating for all pairs of customers having the same rating, each pair should come once only. There should be three columns displayed as Customer1, Customer2, rating. Eg – Ram, Sita, 500. Ram and Sita are pair of customers who have the same rating as 500.Sort the result by rating in descending order and then by customer 1 in descending order and then by customer 2 in descending order.

Answers (3)