---
title: "Discussion on \"GROUP BY doesn't sum all numeric rows but... I have a workaround.\" | Hashnode"
description: "Discussion on \"GROUP BY doesn't sum all numeric rows but... I have a workaround.\". Why would you want to sum the numbers of the rows that were grouped by?\nThe problem:\nLet's say we have a database that records the transactions of our user row by row. Like this:\n\nBut we don't want or need to display transaction by transaction. It wo..."
url: "https://hashnode.com/posts/sqlite3-group-by-with-sum/624b3d1f4b4dde0dc0beb1cf"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [GROUP BY doesn't sum all numeric rows but... I have a workaround.](https://lukasalbus.dev/sqlite3-group-by-with-sum?utm_source=hashnode&utm_medium=feed)

Why would you want to sum the numbers of the rows that were grouped by? The problem: Let's say we have a database that records the transactions of our user row by row. Like this: But we don't want or need to display transaction by transaction. It wo...

Apr 4, 2022 · 1 min read · lukasalbus.dev  
Read the article

-   [#sqlite](https://hashnode.com/tag/sqlite)
-   [#databases](https://hashnode.com/tag/databases)

## Written by

[Lukas Albus](https://hashnode.com/@LukasAlbus)

@LukasAlbus

  
[View profile](https://hashnode.com/@LukasAlbus)

From english teacher to programmer!

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
