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
What is primefaces used for?
What is an external table?
How to connect the oracle server as sysdba?
How to assign values to data fields in record variables?
How to create a new view in oracle?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
What is a tns service name?
What is oracle data type?
How to create a single index for multiple columns?
What is the usage of control file in oracle?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
What is user managed backup in Oracle?
What is a Garbage Collection? and what is full recursive Garbage collection?
interview questions with answer for cts
Describe the types of sub query?