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.

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

definition of cluster and non-clustered index?

2474


Give the constructs of a package, function or a procedure.

531


What are internal user account in oracle?

567


How to create tables for odbc connection testing?

485


Respected sir, Please send me technical questions related to oracle apps..

1369






What is transport network substrate (tns) in oracle?

584


How to write date and time literals in oracle?

548


How do you bind variables in oracle?

540


What is a sub query? Describe its types?

536


What is logical backup in oracle?

571


How to use like conditions in oracle?

564


How to view all columns in an existing table?

545


What is a sub query? What are its various types?

578


How to load data through external tables?

576


How to set up autotrace for a user account?

586