Assume we have one query to find 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. In which order should these clauses be used in the query?

 Posted by Bandi on 11/25/2013 | Category: Sql Server Interview questions | Views: 7741 | Points: 40
Select from following answers:
  1. HAVING, GROUP BY, ORDER BY
  2. GROUP BY, HAVING, ORDER BY
  3. GROUP BY, ORDER BY, HAVING
  4. ORDER BY, GROUP BY, HAVING
  5. All Above

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response