Skip
Arish's avatar

124. Arithmetic on Columns


Column Arithmetic

sql
1SELECT name, marks, marks + 10 AS bonus_marks FROM students;
2
3SELECT name, marks * 1.1 AS curved_marks FROM students;

Operators

OperatorMeaning
+Addition
-Subtraction
*Multiplication
/Division
%Modulo