You have a database that has a productdetails table containing more than one rows for each product. each product assigned an productId to identify product. you excute the following query against above table:

select productid,sum(price)as total
from productdetails
group by productid
order by total desc
offset 0 rows fetch next 10 rows only