Shulou(Shulou.com)06/01 Report--

This article mainly introduces the writing method of sql summation sentence, which has certain reference value and can be used for reference by friends who need it. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.

There is a summation function in the SQL statement that can be used to sum. This function is the sum function, which returns the total (total) of the numeric column.

First, let's look at the syntax of the sum function.

SELECT SUM (column_name) FROM table_name

Let's take a look at specific examples.

Let's look at the table below.

Now we need to add the numbers of the OrderPrice column.

The SQL statement is as follows

SELECT SUM (OrderPrice) AS OrderTotal FROM Orders

The result is: 5700

Thank you for reading this article carefully. I hope it will be helpful for everyone to share the content of the sql summation sentence. At the same time, I also hope that you will support us, pay attention to the industry information channel, and find out if you encounter problems. Detailed solutions are waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.