Home » SQL & PL/SQL » SQL & PL/SQL » Oracle 9i Help!
Oracle 9i Help! [message #6746] Sun, 04 May 2003 21:11 Go to next message
Nazma Bepat
Messages: 34
Registered: May 2003
Member
My question:

Write a query to display all of the grades that are not between 85 and 95.

My answer:

Select Grades
From grade
WHERE grade BETWEEN 85 AND 95

Someone please let me know why it does not work for me. I am doing something that is not correct.

Thanks

Nazma

Report message to a moderator

Re: Oracle 9i Help! [message #6747 is a reply to message #6746] Sun, 04 May 2003 23:49 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Write a query to display all of the grades that are not between 85 and 95.

Your answer selects the inverse. So try this:
Select Grades
From grade
WHERE grade NOT BETWEEN 85 AND 95

MHE

Report message to a moderator

Re: Oracle 9i Help! [message #6775 is a reply to message #6746] Tue, 06 May 2003 01:54 Go to previous message
sachin kumar gupta
Messages: 157
Registered: March 2003
Senior Member
Select Grades
From grade
WHERE grades not BETWEEN 85 AND 95;

Regards,
Sachin

Report message to a moderator

Previous Topic: Possible bugs in a book
Next Topic: commit and rollback in triggers
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 19:57:07 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.