In which order should the below clauses be used in the query that works out the count of products within each category by grouping on the category, filtering by categories that contain more than one product and then sorting the results in category order ?

 Posted by Bandi on 8/29/2017 | Category: Sql Server Interview questions | Views: 1064 | Points: 40
Select from following answers:
  1. HAVING, GROUP BY, ORDER BY
  2. GROUP BY, HAVING, ORDER BY
  3. HAVING, ORDER BY, GROUP BY
  4. None
  5. All Above

Show Correct Answer


| Alert Moderator 

Comments or Responses

Login to post response