Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
How to generate grand total for the total column as a separate result in SQL server?
on 11/14/2013 | Category:
Sql Server Interview questions
| Views: 6320 |
Select from following answers:
A COMPUTE BY clause allows you to see both detail and summary rows with one SELECT statement. You can calculate summary values for subgroups, or a summary value for the whole result set.
SELECT department_id, COUNT(*) as Total
GROUP BY department_id
Show Correct Answer
Many Interviews |
< Previous :
What should be the attribute for a Model property ...
Next > :
Which of the following datepart argument is used t ...
Comments or Responses
Login to post response
More Interview Questions by Bandi
Which of the following datepart argument is used to get the MINUTE val ...
What is the output of select ISNULL(10, getdate()) as 'IsNullWithD ...
What is the output of select COALESCE(10, getdate()) as 'COALESCE& ...
Which of the following CANNOT be passed back as an output parameter fr ...
Which word is missing from the following statement to create a stored ...
Which of the following is the standard four-part naming convention whe ...
What is missing from the T-SQL statement below for creating and using ...
One table has historical transactions details. The table only has 10 c ...
Latest Interview Questions
How does Garbage Collector works?
What is the maximum capacity of a DataTable in ADO.NET?
What is the use of Html.ValidationSummary helper method in ASP.NET MVC ...
How to write dashed attributes of html (5) element using ASP.NET MVC H ...
What is the use of ViewStart in ASP.NET MVC?
What different types of Scaffold templates are there in ASP.NET MVC?
you need to identify Is Always a number Is Always greater than a 65, ...
What is a Linked Server?