Answer: The ROLLUP clause is used to do aggregate operations on multiple levels of hierarchy. If we want a sum on different levels without adding new columns, then we can do it easily by using ROLLUP. We have to just add the WITH ROLLUP clause in the GROUP BY CLAUSE.
What is ROLLUP clause?
Answer: The ROLLUP clause is used to do aggregate operations on multiple levels of hierarchy. If we want a sum on different levels without adding new columns, then we can do it easily by using ROLLUP. We have to just add the WITH ROLLUP clause in the GROUP BY CLAUSE.
0 comments:
Post a Comment