I have a dataset and I need to create another dataset with the result of a query to the first dataset.
First dataset has three columns: id, code and amount and I need a new dataset with the total amount for each id
SELECT SUM(amount) AS total, id FROM myTable GROUP BY id
But I don´t know how to query the first dataset
I hope it will be clear enough