Question: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.
A Select * from Products order by CurrentStock,ProductGroup
B Select * from Products order by CurrentStock DESC,ProductGroup
C Select * from Products order by ProductGroup,CurrentStock
D Select * from Products order by ProductGroup,CurrentStock DESC
E None of these above
+ AnswerD
+ Report