The ROLLUP command in SQL is used to generate subtotals and grand totals in the result set of a query. It is helpful for creating hierarchical reports with aggregated data. ROLLUP generates multiple levels of grouping based on the specified columns, allowing you to obtain summary information at various levels of granularity in a single query.