Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4912 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / girija.112
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 |
Post New Answer View All Answers
How to assign values to data fields in record variables?
What is parameterized cursor in oracle?
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
What is the difference between sharding and replication?
How to define a variable of a specific record type?
What is the relationship among database, tablespace and data file?
What is an oracle wallet?
What is not equal to in oracle?
What happens to the indexes if a table is recovered?
How does the on-delete-cascade statement work?
How to connect to oracle using service name instead of sid?
What is a server parameter file in oracle?
How would you best determine why your MVIEW couldnt FAST REFRESH?
Difference between cartesian join and cross join?
