SQL Sum Function


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.

Post a Comment

0 Comments