Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
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?
on 11/25/2013 | Category:
Sql Server Interview questions
| Views: 6087 |
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 and following by HAVING will filters the summarized data so that we have the categories that contain more than one product and then ORDER BY clause for sorting the results in category order
Show Correct Answer
Many Interviews |
< Previous :
How to delete a stored procedure named as MyProc f ...
Next > :
If you use the BEGIN TRANSACTION statement, then e ...
Comments or Responses
Login to post response
More Interview Questions by Bandi
If you use the BEGIN TRANSACTION statement, then execute 2 insert stat ...
Which of the following is FALSE regarding FOREIGN KEYS in SQL Server 2 ...
Which of the following is an example of a scalar subquery?
What is wrong with the T-SQL batch statement below: @find varchar(30 ...
A Customers table has columns names as firstname and lastname. Which o ...
Which of the following is FALSE regarding PRIMARY KEYS in SQL Server 2 ...
How to enforce rules for the type of information that can be stored in ...
Which of the following transaction isolation levels is the default in ...
Latest Interview Questions
Which statement is False about Optional parameters in VB.Net?
How to get Row Index in MySQL?
How to get Table row no/row index in sql-server.
In case we are returning anonymous type from Controller to the views, ...
How many ways to compare String values in Dot Net?
In Gridview' RowEditing event, what piece of code should be writte ...
In Gridview' RowCancelingEdit event, what piece of code should be ...