Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
You're creating a new query that will select rows from a products tables. The query 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. In which order should these clauses be used in the query?
on 7/30/2014 | Category:
Sql Server Interview questions
| Views: 442 |
Select from following answers:
HAVING, GROUP BY, ORDER BY
GROUP BY, HAVING, ORDER BY
GROUP BY, ORDER BY, HAVING
ORDER BY, GROUP BY, HAVING
GROUP BY is for grouping data into categories
HAVING clause is for filtering the above summerized data, and ORDER BY clause is for sorting the final result set
Show Correct Answer
Many Interviews |
< Previous :
SQL Server 2012 uses the standard four-part naming ...
Next > :
You need to delete a stored procedure from the SQL ...
Comments or Responses
Login to post response
More Interview Questions by Bandi
You need to delete a stored procedure from the SQL Server 2012 databas ...
Your manager has asked you to check the index stats for a particular t ...
Which of the following CANNOT be passed back as an output parameter fr ...
Which of the following generates control-breaks and subtotals in the r ...
You've created a simple select statement that returns the customer ...
Your manager has asked you to design a new table and enforce rules for ...
which of the following SP will be useful to show the active user conne ...
One of the developers at your company has written a CLT stored procedu ...
Latest Interview Questions
By default,Asp.Net stores SessionIDs in which mechanism?
In order to prevent a browser from caching a page which of the stateme ...
We have defined one page_load event in aspx page and the same is defin ...
How to display a computer code in html
What is the FEATURES or PURPOSE of Raise Error?
Can a Clustered Index ALSO be a Unique Index?
Which statement is used for defining a Cursor?
Which Process is used for Maintaining State Server Session in Asp.Net ...