addition
Lets say a company boss thought about providing a 2000 cash bonus to every employee. Now using an additional operator we can easily achieve this.
Syntax –
SELECT (attribute_name + ?) FROM table_name;
Subtraction
Lets say, a company boss thought to deduct 5000cash from every employee in the company due to company sales loss. Now using an additional operator we can easily achieve this.
Syntax – SELECT (? – attribute_name) FROM table_name;
Multiplication
Lets see how we can use multiplication operator(*) into tables.
Syntax – SELECT (attribute_name * ?) FROM table_name;
Division
Lets see how we can use division operator(/) into tables.
Syntax – SELECT (attribute_name / ?) FROM table_name;
Concatenation
Syntax – SELECT CONCAT(‘sample text’,’attribute_name’) FROM table_name;
