TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Syed Arbab Ahmed
NA
104
0
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?
Reply
Answers (
3
)
Combine the output of 2 cursors
plsql