Introduction of rollup clause using sum and group by clause?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

Explain hostprotectionattribute in sql server 2005?

0 Answers  


How can we get count of the number of records in a table?

0 Answers  


What do you understand by replication in sql server? Mention the different types of replication in sql server.

0 Answers  


how to create a scrollable cursor with the scroll option? : Sql server database administration

0 Answers  


How is a full-text index updated?

0 Answers  


How to create nested stored procedure?

0 Answers  


Write a stored procedure for emplpoyee and department table to get DeptName which having no employee. Table Structure- Emp-Emp_Id,Emp_Name,Dept_id Dept-Dept_Id,Dept_Name

7 Answers   TCS,


what is difference between primary key and Unique

8 Answers  


i want only duplicates rows from coloumn ex. emp_id(colomn name)1,1,2,3,3,4,5,5. so i want only duplicates no.

3 Answers   iFlex,


How to create a view using data from another view?

0 Answers  


What is user-defined scalar function?

0 Answers  


hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

0 Answers  


Categories