Query problem in Oracle 9i
I am having problem of understanding query in book of Oracle 9i, the query is this:
select empno,ename,sal
from emp
where sal>900
and ename between 'QUENTIN' and 'ZYRYRAB';
EMPNO ENAME SAL
---------- ---------- ----------
7521 WARD 1250
7788 SCOTT 3000
7844 TURNER 1500
3 rows selected.
I want to know how 'QUENTIN' and 'ZYRYRAB' works, because I simply don't get how'QUENTIN' and 'ZYRYRAB' eliminates KING which makes more money than WARD,SCOTT , TURNER the book says that KING's last name does not fall between 'QUENTIN' and 'ZYRYRAB', 1st of all I have not yet seen last name or full name all I in the tables are just single names then what book is talking about last name? And also'QUENTIN' and 'ZYRYRAB' works I simply don't get.
Could u plz help me understanding the above mention problem?