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.
0faunaOrunsu Dennis Steele https://wakelet.com/wake/CZ9sygkzbhfjathshR9pE
ReplyDeletepalourere