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
- 6954 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
How to view the data files in the current database?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
What is the database name in oracle?
what is meant by magic query
What is dynamic proxy?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
What is the usage of control file in oracle?
How to fetch the row which has the max value for a column?
Can we create database in oracle using command line ?
What is format trigger?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
What are ddl statements in oracle?
What are the varoius components of physical database structure of oracle database?
What is a nested table and how is it different from a normal table?
