> > >

Access MCQs

Choose the appropriate query for the Products table where data should be displayed primarily in ascending order of the ProductGroup column. Secondary sorting should be in the descending order of the CurrentStock column.

Select * from Products order by CurrentStock, ProductGroup.

Select * from Products order by CurrentStock DESC, ProductGroup.

Select * from Products order by ProductGroup, CurrentStock.

Select * from Products order by ProductGroup, CurrentStock DESC.

None of the above.

Answer

Correct Answer: Select * from Products order by ProductGroup, CurrentStock DESC.

Explanation:

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

Access Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it