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

What is implicit cursors?

0 Answers  


What is the difference between join and inner join?

0 Answers  


What is query and its types?

0 Answers  


What are page splits? : SQL Server Architecture

0 Answers  


Can multiple columns be used in sql group by clause in ms sql server?

0 Answers  


Do you know what are acid properties of transaction?

0 Answers  


what is database replicaion? : Sql server database administration

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  


How to count groups returned with the group by clause in ms sql server?

0 Answers  


What are the disadvantages of using querystrings to send data from one page to another?

0 Answers  


can you any body tell me simple recovery,full recovery,bulk logged recovery where can use?

1 Answers  


Where are full-text indexes stored?

0 Answers  


Categories