select * from order_line where itemnum between 1 and 200 or itemnum>100

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 / murali

3 Answers
5122 Views
Wipro, I also Faced
E-Mail Answers

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do I use os authentication with weblogic jdriver for oracle and connection pools?

1098

What are the types of partitions in oracle?

1079

Why is oracle used?

980

What are the differences between lov and list item?

1147

What are operators in oracle?

1103

How to define an oracle sub procedure?

1232

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4415

How are extents allocated to a segment?

1182

What is a dynamic performance view in oracle?

1059

What is the purpose of tables, private synonyms and public synonyms in Oracle?

1094

How to drop an index?

1015

How can we find out the current date and time in oracle?

1132

Please explain oracle left join with an example?

1095

Can we use bind variables in oracle stored procedure?

987

What is a proxy object?

1109