Database - OPERATORS

Comparison operator:  =,<>,!=,<,>,<=,>=,!<,!>

select * from employee where deptno !< 30

Range operator-BETWEEN,NOT BETWEEN

The BETWEEN operator is used in a WHERE clause to select a range of

data between two values.

The BETWEEN operator selects a range of data between two values.

 The values can be numbers, text, or dates.

Syntax:

SELECT column_name(s)

FROM table_name

WHERE column_name

BETWEEN value1 AND value2

list operator-IN,NOT IN

The IN operator allows you to specify multiple values in a WHERE clause.

Syntax:

SELECT column_name(s)

FROM table_name

WHERE column_name IN (value1,value2,...)

string operator LIKE,NOT LIKE

The LIKE operator is used in a WHERE clause to search for a

specified pattern in a column.

The LIKE operator is used to search for a specified pattern in a column.

Syntax:

SELECT column_name(s)

FROM table_name

WHERE column_name LIKE pattern

logical operator-AND ,OR,NOT

The AND & OR operators are used to filter records

based on more than one condition.

The AND operator displays a record if both

the first condition and the second condition is true.

The OR operator displays a record if either the first

condition or the second condition is true.'