Query problem in Oracle 9i

Jul 16 2009 12:01 PM
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?

Answers (3)