MCQs>IT & Programming>Oracle 12c Admin>Which of the following queries, when run for PurchaseDetails table, will return the names of items and their maximum and minimum prices. such that the maximum price for the items is greater than 600?
Oracle 12c Admin MCQs
Which of the following queries, when run for PurchaseDetails table, will return the names of items and their maximum and minimum prices. such that the maximum price for the items is greater than 600?
Answer
Correct Answer: SELECT ltem_Name, max(Price), min(Price) FROM PurchaseDetails GROUP BY ltem_Name HAVING max(Price) > 600;
Explanation:
Note: This Question is unanswered, help us to find answer for this one