Select custid, ordid, shipdate From ord Where (shipdate

10. Display the client number, order date and shipping date
for all orders where the shipping date is between three and
six months after the order date.

Question Posted / devraj

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

Answer Posted / devraj

Select custid, ordid, shipdate From ord Where (shipdate -
orderdate) Between 3 And 6;

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is oracle used for?

1071

What is the relationship among database, tablespace and data file?

1039

What is a system tablespace and when it is created?

1018

How to use existing values in update statements using oracle?

1115

What is meant by recursive hints in oracle?

1134

Point out the difference between user tables and data dictionary?

1038

What is the difference between $oracle_base and $oracle_home?

1137

How to use like conditions in oracle?

1115

How to create a stored function in oracle?

1158

Is it possible to split the print reviewer into more than one region ?

2342

What is meant by an index?

1224

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

1046

How to concatenate two text values in oracle?

1159

How to rebuild an index in oracle?

1070

How to compare dates in oracle sql?

1162