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.
- 3 Answers
- 5671 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / subhajit acharyya
select clientnumber,ordate,shipping date from order where
months_between(shipping date,ordate) between 3 and 6;
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / devraj
Select custid, ordid, shipdate From ord Where (shipdate -
orderdate) Between 3 And 6;
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / mk
elect clientnumber,ordate,shipping date from order where
datediff(mm,Orderdate,Shipping date) In (3,6);
| Is This Answer Correct ? | 0 Yes | 0 No |
How to export data to a csv file?
What are the components of Logical database structure of ORACLE database?
Can we call procedure inside function in oracle?
what are stored procedures?
What is the difference between a vector and an Array? (Java)
What happens in oracle commit?
How to drop a stored function?
can you explain performance tunning in oracle(sql,PL/SQL)
Query to get max and second max in oracle in one query ?
34 Answers CTS, Keane India Ltd, TCS, Wipro,
How to create a table interactively?
What do you understand by a database object? Can you list a few of them?
Does a Before form trigger fire when the parameter form is suppressed ?
Oracle General 
