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 

+ Answer
+ Report
Total Preview: 8429

Copyright © 2024. Powered by Intellect Software Ltd