3leftturns/sum and group by sql

Created June 13, 2014 16:55

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/3leftturns/86b86122c93a4f89281c.js"></script>
Save 3leftturns/86b86122c93a4f89281c to your computer and use it in GitHub Desktop.

Download ZIP

Got a list of sales in a table and need to summarize total sales for each sales agent? This GIST can help. Selects sales agent and sums their sales, then groups into 1 line per sales agent.

Raw

sum and group by sql

	SELECT salesagent, SUM(saleamount) as salestotal
	FROM sales.salestable
	GROUP BY salesagent;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment