Aggregate Functions in SQLite

Question

If I have a table containing a column of text and a column of integers, how can I sum the integers specific to each text entry? Example:

text1 | 4
text2 | 2
text3 | 5
text2 | 3
text1 | 2

I want to do: SELECT Text,SUM(Number) FROM TABLE

However, that sums all the numbers together (text1 | 16). How can I sum the numbers with each text entry independently?( text1 | 6 text2 | 5 text3 | 5 )

mechanical_meat · Accepted Answer · 2012-05-15 18:01:02Z

4

Have a look at the GROUP BY clause: http://www.sqlite.org/lang_select.html#resultset

Example usage:

SELECT   mycolumn, SUM(myothercolumn) 
FROM     mytable
GROUP BY mycolumn
ORDER BY mycolumn;

answered May 15, 2012 at 18:01

mechanical_meat

170k25 gold badges238 silver badges231 bronze badges

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

1 Comment

V1rtua1An0ma1y Over a year ago

I think I had done GROUP BY on "myothercolumn" and ORDER BY separately, but never though to combine them. You're exactly right in the example you gave back. Thank you kindly :)

Collectives™ on Stack Overflow

Aggregate Functions in SQLite

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