I need to calculate the running total in which the target column is changing along with the time. Its something which aws does. Charging based for only what you use. So how do I aggregate sum of ...
this isn't the usual Select top N results from each category question - there's a little bit more to it. I have the Select top N query as follows: SELECT tmp.id, tmp.name, tmp.category_id, ...