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
- 6685 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What do you understand by database schema and what does it hold?
What do you mean by merge in oracle and how can we merge two tables?
Will you be able to store pictures in the database?
How to count duplicated values in a column in oracle?
Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?
How many categories of data types?
How to use select statement to count the number of rows in oracle?
How do I connect to oracle database?
What is BBED in Oracle?
What is logical backup in oracle?
How many types of database triggers exist?
What are nested tables?
various types of hints and their usage
What is format trigger?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
