Equality Operator (=):

• Used to check if two values are equal.

SELECT * FROM student WHERE rollno = 10;

Inequality Operators (<>, !=):

• Used to check if two values are not equal.

SELECT * FROM student WHERE name <> 'Anurag';

SELECT * FROM student WHERE name != 'Anurag';

Greater Than Operator (>):

• Used to check if a value is greater than another.

SELECT * FROM student WHERE rollno > 1;

Less Than Operator (<):

• Used to check if a value is less than another.

SELECT * FROM student WHERE rollno < 5;

Greater Than or Equal To Operator (>=):

• Used to check if a value is greater than or equal to another.

SELECT * FROM student WHERE rollno >= 2;

Less Than or Equal To Operator (<=):

• Used to check if a value is less than or equal to another.

SELECT * FROM student WHERE rollno <= 20;

LIKE Operator:

• Used for pattern matching with wildcard characters (% and _).

SELECT * FROM student WHERE name like '%rag';

NOT LIKE Operator:

• Used to exclude results based on a pattern.

SELECT * FROM student WHERE rollno not like '%Kumar';

BETWEEN Operator:

• Used to filter results within a specified range.

SELECT * FROM student WHERE rollno between 2 and 5;

NOT BETWEEN Operator:

• Used to exclude results outside a specified range.

SELECT * FROM student WHERE rollno not between 2 and 5;

IN Operator:

• Used to check if a value matches any value in a list

SELECT * FROM student WHERE rollno in (2,5,10);

NOT IN Operator:

• Used to check if a value does not match any value in a list.

SELECT * FROM student WHERE rollno not in (2,5,10);

IS NULL Operator:

• Used to check if a column has a NULL value.

SELECT * FROM student WHERE batch is null;

IS NOT NULL Operator:

• Used to check if a column does not have a NULL value.

SELECT * FROM student WHERE batch is not null;