DATABASE & SQL/PLSQL

Using Comparison Operators

Comparison operator allow row retrieval from a table based on the condition specified in the WHERE clause.

SELECT column_list
FROM table_name
WHERE expression1 comparison_operator  expression2

Example:

SELECT pub_id
FROM publishers
WHERE city='Boston'

Using Range Operators

The range operator is used to retrieve data between range . The range operator are:

1. BETWEEN: Specified an inclusive range to search.

SELECT column_list
FROM table_name
WHERE expression1 BETWEEN expression1 AND expression1

Example:

Below query return the attribute list value between 2000 and 5000.

SELECT *
FROM titles
WHERE advance BETWEEN 2000 AND 5000

2. NOT BETWEEN: This key word used to exclude the rows from the specified range in the result set.

SELECT column_list
FROM table_name
WHERE expression1 NOT BETWEEN expression1 AND expression1

Example:

Below query return the attribute list value which not between 2000 and 5000

SELECT *
FROM titles
WHERE advance NOT BETWEEN 2000 AND 5000