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
How to create a stored procedure in oracle?
Explain the difference between sap and oracle?
How can we delete duplicate rows in a table?
How to select all columns of all rows from a table in oracle?
How to store only time; not date and time?
Explain about your project and its relation to the current job position you are applying to?
How to name query output columns in oracle?
How to use group functions in the select clause using oracle?
Explain mutating triggers.
What is background process in Oracle?
What is the difference between a primary key & a unique key?
How to define an oracle cursor variable?
How to import one table back from a dump file?
What is bulk load in oracle?
Query to retrieve record for a many to many relationship ?