> > >

MySQL MCQs

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?

select item, brand, price from items where max(price) order by item

select * from items where price = max group by item

select item, brand, max(price) from items group by item

select * from items where price > 200 order by item

Answer

Correct Answer: select item, brand, max(price) from items group by item

Explanation:

Note: This Question is unanswered, help us to find answer for this one

MySQL Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it