**Sum Function In SQL**

**SUM()**

Sum Function is used to
Display The Total Sum of A Column,

Sum function are used to Display the total sum of a numeric
column

NOTE- for the Sum function column
should be numeric.

**Sum() Syntax-**The Basic Syntax For Sum Function are given Below

Sum Function Without Condition

SELECT SUM(column_name)FROM table_name;

Sum Function With Condition

SELECT SUM(column_name)FROM table_name WHERE condition;

**Example OF Sum () Function**

SQL Query-

SELECT SUM(Marks)FROM Student;

In Above Example It Will Display The Total Sum Of Marks Column
in Student Table.

## 0 Comments