MySql SUM function combined with where conditional

Question

This is the first part of a crazy query I have to put together so expect another question on here soon!

I have this table Table Description

What I am trying to do is to get a list of CONTEXT that have a SUM(FILE_SIZE) greater than 5 gigs.

I have every part of the query figured out except putting in the where clause.

SELECT CONTEXT,SUM(FILE_SIZE) AS size FROM CONTENT_RESOURCE GROUP BY CONTEXT.

What I'm having trouble putting together is something like:

WHERE SUM(FILE_SIZE) > 5000000000

This would be done for each unique CONTEXT.

So if there is data like this:

1 | A
4 | A
2 | C
6 | C
8 | B

The result would be something like:

5 | A
8 | C
8 | B

So I need to get the SUM(FILE_SIZE) for all of the different CONTEXTs and then only return the ones where it is greater than 5000000000

Mureinik · Accepted Answer · 2014-12-05 14:49:38Z

2

The having clause allows you to apply conditions on groups (and aggregate results) created by the group by clause:

SELECT   context, SUM(file_size) AS size 
FROM     content_resource
GROUP BY context
HAVING   SUM(file_size) > 5000000000

answered Dec 5, 2014 at 14:49

Mureinik

316k54 gold badges401 silver badges405 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Zeratas Over a year ago

Thanks! I didn't run the query yet as it takes 10-20 minutes to complete but I tested it on a smaller data set and it looked like it worked. Expect a few more SQL questions today too!

Collectives™ on Stack Overflow

MySql SUM function combined with where conditional

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related