> > >

Microsoft SQL Server 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 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

Microsoft SQL Server Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it