Equal to Greater than Less than Not Equal to Operators in SQL

For Complete YouTube Video: Click Here

This class will understand Equal to Greater than Less than Not Equal to Operators in SQL.

We have already discussed the concepts of Commit and Rollback in SQL.

Before understanding the above operators, we will try to understand the single value operator.

Single Value Operators make logical tests against single values.

select * from students where salary = 300;

In the above query, salary = 300, the ‘equal to’ operator can test only one value.

The following are the single value test operators.

Equal to =
Greater Than >
Less Than <

Greater Than Equal to >=
Less Than Equal to <=

Not Equal to !=, ^=, <>

LIKE
IS NULL
IS NOT NULL

LIKE, IS NULL, and IS NOT NULL are also single value operators.

We will see about them in our next classes.

Now we will test each operator individually and see the outputs.

The use of the ‘equal to’ operator is as shown below.

The students whose salaries are ‘equal to’ 300 got selected.

The use of the ‘greater than’ operator is as shown below.

The students whose salaries are ‘greater than’ 300 got selected.

The use of the ‘greater than or equal to’ operator is as shown below.

The students whose salaries are ‘greater than or equal to’ 300 got selected.

Similarly, you can visualize for less than and less than or equal to also.

The use of the ‘not equal to’ with all the operators is as shown below.

The students whose salaries are ‘ not equal to’ 300 got selected.