Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6960 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 |
Can a formula column be obtained through a select statement ?
How to empty your oracle recycle bin?
Youre getting high busy buffer waits - how can you find whats causing it?
What is memory advisor in Oracle?
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
What privilege is needed for a user to query tables in another schema?
Explain rename?
Please explain the difference between outer join and inner join? With examples would be appreciable..!
How to export your own schema?
what is exact difference between drop and truncate table.
How to specify default values in insert statement using oracle?
What is Reduced List of Values?
Oracle General 
