Tutorial 1, page 8 Context: jobsEngine: oracle

Some comparisons, like "is it between two numbers" starts to look quite complex using > and < signs. Consider looking for an empno between 3 and 5 inclusive:

select empno from employee
where empno<=5 and empno>=3

This can be rewritten using BETWEEN:

select empno from employee
where empno BETWEEN 3 and 5

Now find the course names (cname) in table COURSE where the cdate is between the start and end of 1988. A date looks like '01-Jan-1988', and you must always include the day, month, and year.

Active SQL index Previous Question             

SQL To Be Executed