Question:Suppose a table has the following records:

+--------------+-------------+----------------+
| Item         | Price       | Brand          |
+--------------+-------------+----------------+
| Watch        | 100         | abc            |
| Watch        | 200         | xyz            |
| Glasses      | 300         | bcd            |
| Watch        | 500         | def            |
| Glasses      | 600         | fgh            |
+--------------+-------------+----------------+

Which of the following will select the highest-priced record per item? 

A select item, brand, price from items where max(price) order by item 
B select * from items where price = max group by item 
C select item, brand, max(price) from items group by item 
D select * from items where price > 200 order by item 

+ Answer
A 

+ Report

Mohammad Towhidul Islam

Editor, VCampus

Your Name

Your Email

Type of Report
Spelling MistakeIncorrect AnswerGrammar MistakeContent MissingImproper Text FormatInsufficient AnswerDuplicate QuestionImproper Sentence StructureImproper Equation/FormulaOther

Description