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
definition of cluster and non-clustered index?
Give the constructs of a package, function or a procedure.
What are internal user account in oracle?
How to create tables for odbc connection testing?
Respected sir, Please send me technical questions related to oracle apps..
What is transport network substrate (tns) in oracle?
How to write date and time literals in oracle?
How do you bind variables in oracle?
What is a sub query? Describe its types?
What is logical backup in oracle?
How to use like conditions in oracle?
How to view all columns in an existing table?
What is a sub query? What are its various types?
How to load data through external tables?
How to set up autotrace for a user account?