select * from order_line where ( (itemnum between 1 and 200) or itemnum &

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.

Question Posted / suman rana

3 Answers
5123 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

Please Help Members By Posting Answers For Below Questions

What is a cursor and what are the steps need to be taken?

1290

How to create a new table by selecting rows from another table?

1151

What is meant by joins?

1109

How to join two tables in a single query using oracle?

1054

What is a package in oracle?

1163

What are a collation and state the different types of collation sensitivity?

1243

Can we insert data in view oracle?

1120

WHAT IS ecc 6.0

2205

What is literal?

1063

What is max rowid in oracle?

1084

How to create a server parameter file?

1188

Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

2364

What is a private synonym?

1647

Give the various exception types.

1040

How to fetch the row which has the max value for a column?

1046