## Arithmetic Operators

Arithmetic operators are +, -, *, /, % performs addition, subtraction, multiplication, division, modulo respectively.

Example:

• Select 100+222;
• Select salary+100

From teacher

Where teacher_id=1; Following output screen shows different arithmetic operations. We can perform single operation at a time or multiple operations. ## Comparison Operators

Comparison operators ‘<’,   ‘<=’, ‘>’, >, =’, =’ performs less than, less than equal, greater than, greater than equal, equal respectively. Following output screen shows different comparison operators. Following output screen shows different queries with different comparison operations. ## Logical Operators

AND, OR, NOT, LIKE, IN, BETWEEN, ALL, SOME, ANY, EXISTS are logical operators from which some operators ALL, ANY, EXISTS, SOME used in sub queries.

AND: It returns TRUE, if all the conditions separated by AND are TRUE.

Example:

Select *

from teacher

where salary>10000

and

dept_name=’CS’; OR: It returns TRUE, if any of the conditions separated by OR is TRUE.

Example:

Select *

from teacher

where salary < 10000

OR

dept_name=’IT’; BETWEEN: It returns true, if the operands are within the range of comparison.

Example:

Select *

from teacher

where teacher_id between 4 and 8; IN: It returns true if the operand is equal to one of the list of expressions.

Example:

Select *

from teacher

where teacher_id in (4,8); LIKE: It returns true if the operand matches a pattern. ‘_’ underscore represents single character. ‘%’ percent represents one or more characters.

Example:

Select teacher_name

from teacher

where teacher_name like ‘a%’; Q2 Find out teachers whose name end with ‘r’?

Select teacher_name

from teacher

where teacher_name like ‘%r’; Q3 Find out teachers whose name contains letter ‘h’?

Select teacher_name

from teacher

where teacher_name like ‘%h%’; Q4 Find out teacher whose name contains ‘h’ letter at third position?

Select teacher_name

from teacher

where teacher_name like ‘__h%’; If the condition is not true.

Example:

Select teacher_name

from teacher

where teacher_name NOT like ‘%h%’; Reference:
https://www.javatpoint.com/sql-operators