SQL SUM Command

SELECT sum( column_name ) FROM table_name

SELECT SUM( mark ) FROM `student`

SELECT SUM(mark) as total_mark FROM `student`

GROUP By with SUM Query

SELECT class, sum( mark ) as total_mark FROM`student` GROUP BY class

WHERE with SUM Query

SELECT SUM( mark ) as total_mark, class FROM student WHERE  mark > 55 GROUP BY class

Other sql commands like between can be used along with this sum command to find out required results.

IN with SUM Query

SELECT sum( mark ) FROM `student` where id IN(1,2,3,4)

Math Formula with SUM Query

SELECT SUM(sell_price - buy_price) as Profit  FROM plus2_product

SELECT SUM(sell_price - buy_price) as Profit  FROM plus2_product WHERE product ='Product1'

Total value of the column at the end of the table

SELECT product,buy_price,sell_price FROM plus2_product
UNION
SELECT 'Total:',SUM(buy_price),SUM(sell_price) FROM plus2_product

CREATE TABLE IF NOT EXISTS `plus2_product` (
  `product` varchar(20) NOT NULL,
  `buy_price` int(3) NOT NULL,
  `sell_price` int(3) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `plus2_product`
--

INSERT INTO `plus2_product` (`product`, `buy_price`, `sell_price`) VALUES
('Product1', 20, 22),
('Product2', 15, 20),
('Product3', 40, 43),
('Product1', 50, 45);