DEV Community

SQL Math Functions with Use Cases

Ashfiquzzaman Sajal on November 28, 2023

In this context, ABS(x): Returns the absolute value of the input value 'x'. For example, ABS(-10) would return 10. ROUND(x, d): Rounds the input ...

Read full post

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;

This will aggregate the sales by category and display the result for the product category against the product row,

Thanks for the information Reese.

Don't forget to share your valuable comments!