How would you show aggregation on the whole data row by row in SQL? For example, if I want total sales as a new column in the existing table as a result.

Question

Accepted Answer

To show aggregation on whole data row by row in SQL, you can use the OVER() function with appropriate window specification.

Use the OVER() function to perform aggregation on the entire data set
Specify the window specification to define the scope of aggregation
Add the aggregated result as a new column in the existing table
Example: SELECT *, SUM(sales) OVER() AS total_sales FROM table_name

Accepted Answer

We can use Windows function to achieve this.