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
- 6686 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the quickest way to fetch the data from a table?
How to display employee records who gets more salary than the average salary in the department?
What privilege is needed for a user to delete rows from tables in another schema?
What is control file used for?
What is the exact use of Collections?
What is the difference between a user and a schema in oracle?
Can we insert data in view oracle?
Explain the importance of .pll extension in oracle?
Explain the dml?
How to bring a tablespace online?
Explain the features of oracle?
How to divide query output into groups in oracle?
What is truncate oracle?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
What is a named program unit?
