Performing Range Tests with comparison operators : Comparison Operators « Select Query « Oracle PL / SQL

1. Oracle PL / SQL
2. Select Query
3. Comparison Operators

Performing Range Tests with comparison operators

  
SQL>
SQL> CREATE TABLE emp (
  2     empID      INT NOT NULL PRIMARY KEY,
  3     CourseID    INT NOT NULL,
  4     ProfessorID INT NOT NULL,
  5     SustainedOn DATE,
  6     Comments    VARCHAR(255));

Table created.

SQL>
SQL> INSERT INTO emp (empID,CourseID,ProfessorID,SustainedOn,Comments) VALUES (1,1,1,DATE '2003-03-12','Hard');

1 row created.

SQL> INSERT INTO emp (empID,CourseID,ProfessorID,SustainedOn,Comments) VALUES (2,2,1,DATE '2003-03-13','Simple');

1 row created.

SQL> INSERT INTO emp (empID,CourseID,ProfessorID,SustainedOn,Comments) VALUES (3,3,2,DATE '2003-03-11','1 hour long');

1 row created.

SQL> INSERT INTO emp (empID,CourseID,ProfessorID,SustainedOn) VALUES (4,4,3,DATE '2003-03-18');

1 row created.

SQL>
SQL> SELECT empID, SustainedOn, Comments FROM emp
  2  WHERE SustainedOn >= DATE '2003-03-20'
  3  AND SustainedOn <= DATE '2003-03-24';

no rows selected

SQL>
SQL> drop table emp;

Table dropped.

   
    
  

Related examples in the same category