DATABASE & SQL/PLSQL

adplus-dvertising
Displaying Rows Using Comparison & Range Operators
Previous Home Next

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
OperatorDescription
=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:

  1. BETWEEN: Specified an inclusive range to search.
  2. 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
    
  3. NOT BETWEEN: This key word used to exclude the rows from the specified range in the result set.
  4. 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
    
Previous Home Next