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
- 5027 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to compare dates in oracle sql?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
How to do clean up if create database failed?
Can you create a synonym without having a table?
Is rowid unique in oracle?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
How to connect to oracle using service name instead of sid?
What are the limitations oracle database 10g xe?
How to get execution path reports on query statements?
What is oracle analytical function?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
How to load a large xml file?
How to use values from other tables in update statements using oracle?
Explain drop constraint oracle?
Name the various constraints used in oracle?
