how to calculate sum for every 5 rows in sql

Hi Nag,

Assuming that you wish to calculate the total sum for each of both the products that you have in column 'name'(4 rows for product xyz and 4 rows for product hhh) within your table, you can use the aggregate SQL function SUM() along with 'Group By' clause in a SQL query, just like in the following example:

SELECT t.name, SUM(t.amount) AS Total

FROM table_name t

GROUP BY t.name

As a result of the grouping performed you will have:

----------------

name|Total

1|hhh |9180

2|xyz |1311

----------------

I hope that the provided example helps.

Best regards,

Stavri