SQL Sum Function


Sum  Function In SQL

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.


Post a Comment