5. Display full details from the ORDER_LINE table where the item number is (fir

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

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

Answers were Sorted based on User's Feedback

5. Display full details from the ORDER_LINE table where the item number is (first condition) betwee..

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

5. Display full details from the ORDER_LINE table where the item number is (first condition) betwee..

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

5. Display full details from the ORDER_LINE table where the item number is (first condition) betwee..

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

Post New Answer