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.
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 are the differences between char and varchar2 in oracle?
How to define a data field as not null?
How to export data with a field delimiter?
What is clustered table in Oracle?
how to handle exceptions in post production
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
What is a cursor and what are the steps need to be taken?
What is a system tablespace and when it is created?
How to run create database statement again?
What do you understand by a database object? Can you list a few of them?
What is the difference between a primary key & a unique key?
Is a rollback possible to any savepoint?
How to add a new column to an existing table with a default value?
How to create tables for odbc connection testing?
What is a user role in oracle?