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
- 6839 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 privilege is needed for a user to query tables in another schema?
Can you tell me how to add new column in existing views?how?How is possible?
How do we get field detail of a table?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
Explain the dml?
What are the benefits of ordbms?
Explain integrity constraints?
What is data file?
Difference between cartesian join and cross join?
How to store pictures on to the database?
How to delete an existing row from a table in oracle?
How to apply filtering criteria at group level in oracle?
How to define a data source name (dsn) in odbc manager?
Explain what are the advantages of views?
Explain the use of parfile option in exp command.
