Question:Select the appropriate query for the Products table when data should be primarily ordered by ProductGroup. ProductGroup should be displayed in ascending order and CurrentStock should be in descending order: 

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 

+ Answer
+ Report
Total Preview: 613

Copyright © 2024. Powered by Intellect Software Ltd