5. Display full details from the ORDER_LINE table where the
item number is (first condition) between 1 and 200 (no > or
< operators) OR the item number is greater than 1000 AND
(second condition) the item cost is not in the list 1000,
2000, 3000 OR the order number is not equal to 1000.
- 3 Answers
- 3833 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
select *
from order_line
where item_number between 1 and 200
or item_number > 1000
intersect
select *
from order_line
where order_number not in (1000,2000,3000)
or order_number <> 1000
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / murali
select * from order_line where
itemnum between 1 and 200 or itemnum>100
and
cost not in (1000,2000,3000) or ordernum<>1000
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / suman rana
select * from order_line
where ( (itemnum between 1 and 200) or itemnum >100)
and not (cost in (1000,2000,3000) or ordernum = 1000)
| Is This Answer Correct ? | 0 Yes | 0 No |
How to run the anonymous block again?
How to retrieve values from data fields in record variables?
How to enter a new row into a table interactively?
What is system global area (sga) in oracle?
Is it possible to split the print reviewer into more than one region ?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
Explain self joins in oracle?
What is the quickest way to fetch the data from a table?
material view and view disadvantages?
How to write date and time interval literals in oracle?
How to write a query with a left outer join in oracle?
write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.
Oracle General 
