If you need to include more information than just the grouped filed and aggregate you can also use the OVER() syntax.
SELECT category, SQRT(SUM(sales)) AS square_root_sales FROM products GROUP BY category;
becomes SELECT category, ProductName, SQRT(SUM(sales) OVER (PARTITION BY category)) AS square_root_sales_of_category FROM products;
SELECT category, ProductName, SQRT(SUM(sales) OVER (PARTITION BY category)) AS square_root_sales_of_category FROM products;
This will aggregate the sales by category and display the result for the product category against the product row,
Thanks for the information Reese.
Are you sure you want to hide this comment? It will become hidden in your post, but will still be visible via the comment's permalink.
Hide child comments as well
Confirm
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
If you need to include more information than just the grouped filed and aggregate you can also use the OVER() syntax.
SELECT category, SQRT(SUM(sales)) AS square_root_salesFROM products
GROUP BY category;
becomes
SELECT category, ProductName, SQRT(SUM(sales) OVER (PARTITION BY category)) AS square_root_sales_of_categoryFROM products;
This will aggregate the sales by category and display the result for the product category against the product row,
Thanks for the information Reese.