Displaying Rows Using Comparison & Range Operators
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
Operator | Description |
= | Equal to |
> | Greater than |
< | Less than |
>= | Greater than or equal to |
<= | Less than or equal to |
<>,!= | Not equal to |
!> | Not greater than |
!< | Not less than |
() | Controls precedence |
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:
- 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
- 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