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
- 6953 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 |
What is a Schema ?
What is using clause and give example?
How to Remove the 3rd highest salary person record from table?
Which Department has MOST NUMBER of employees?
8 Answers IBM, LeadSquared, Mastek,
What is the maximum number of CHECK constraints that can be defined on a column ?
What are the differences between lov and list item?
Explain what does a control file contain?
Explain the difference between sql and oracle?
Do View contain Data ?
Preparing for Oracle PL/SQL Interviews – Need Help with Common Questions
What is the difference between pre-select and pre-query?
What is a cluster?
Oracle General 
