RollUp in Sql Server

Question

Hi, Can you define ROLLUP in SQL SERVER 2005. Thanks

Jignesh Trivedi · Answer

hi, please refer, http://blogs.msdn.com/b/craigfr/archive/2007/09/21/aggregation-with-rollup.aspx http://sqlandme.com/2011/07/07/sql-server-tsql-group-by-with-rollup/ http://blog.sqlauthority.com/2010/02/24/sql-server-introduction-to-rollup-clause/

Prabhu Raja · Answer

Hi, Hope this will help you. http://chiragrdarji.wordpress.com/2008/09/09/group-by-cube-rollup-and-sql-server-2005/

Satyapriya Nayak · Answer

Hi Arjun, The ROLLUP operator is useful in generating reports that contain subtotals and totals. The ROLLUP operator generates a result set that is similar to the result sets generated by the CUBE operator. ROLLUP generates a result set that shows aggregates for a hierarchy of values in the selected columns. ROLLUP work with the "Group By " clause its main functioning comes into existance when we use Group by. We can get sub-total of row by using the Rollup funtion.When result is return by Group By class first row display the grand total or we can say that the main total. syntax:-select firstcolumn,secondcolumn,sum(thirdcolumn) from tablename group by firstcolumn,secondcolumn with rollup order by firstcolumn Please refer the below link http://blog.sqlauthority.com/2010/02/24/sql-server-introduction-to-rollup-clause/ Thanks