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
- 6692 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 get the Installed Oracle Version Information ?
Which is better Oracle or MS SQL? Why?
The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ================ 1 NULL 2 NULL 3 4 NULL 5 6 7 NULL NULL O/P C = 2 4 6
How to define a cusotmer as a supplier in ORACLE R12
What is oracle thin client?
DBMS vs. RDBMS
What happens if the imported table already exists?
How to insert multiple rows with one insert statement in oracle?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
What are the types of partitions in oracle?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
Is oracle the best database?
Oracle General 
