Скачать или смотреть How to Sum Two Columns at Row Level in SQL

Learn how to add values from two columns for each row in your SQL queries and get the desired output efficiently.
---
This video is based on the question https://stackoverflow.com/q/70624039/ asked by the user 'SRJCoding' ( https://stackoverflow.com/u/13806869/ ) and on the answer https://stackoverflow.com/a/70625338/ provided by the user 'AMAN KAG' ( https://stackoverflow.com/u/17862815/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: Summing two columns at row level

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/l...
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license.

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
How to Sum Two Columns at Row Level in SQL: A Quick Guide

When working with databases, it's common to perform calculations on data to gain insights. One such task may involve summing two columns for each row in a database table. In this post, we will discuss how you can easily achieve this in SQL, specifically using DB2 as your database management system.

Understanding the Problem

Imagine you have a table that contains customer IDs along with two measures, say Measure_1 and Measure_2. Your current dataset looks like this:

[[See Video to Reveal this Text or Code Snippet]]

Your goal is to create a new table that outputs each Customer_ID alongside a new column called Total, which is the sum of Measure_1 and Measure_2. The expected output should appear as follows:

[[See Video to Reveal this Text or Code Snippet]]

The SQL Solution

To achieve this, you can use a simple SQL query that performs the addition of the two columns. Below are a couple of ways you can write this SQL command:

Option 1: Using Alias for Total Column

[[See Video to Reveal this Text or Code Snippet]]

In this version, we're using the AS keyword to create an alias for our new column. This makes it clear that we are renaming the result of the addition to Total.

Option 2: Alternative Syntax for Alias

[[See Video to Reveal this Text or Code Snippet]]

This time, we use double quotes to define the alias. Both options are correct, and you can choose whichever appeals to you stylistically.

Important Notes

Ensure that you replace your_table_name with the actual name of the table you're querying.

The addition operation will automatically handle null values. If both Measure_1 and Measure_2 are null for a row, the Total will also be null. Make sure to handle such scenarios according to your needs.

The performance of your query could be influenced by the size of your dataset; however, this operation is straightforward and efficient for most SQL engines, including DB2.

Conclusion

In just a few simple steps, you can sum two columns for each row in your SQL queries. By using aliases, you can enhance the readability of your results, enabling better data insights. Next time you find yourself looking to consolidate data for clearer reporting, use this method to streamline your queries.

With this understanding in hand, you can confidently manipulate data in your SQL tables. Happy querying!