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 / devraj
Select custid, ordid, shipdate From ord Where (shipdate -
orderdate) Between 3 And 6;
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
what is meant by magic query
How to end the current transaction in oracle?
Explain the difference between a procedure and a function? What do you understand by those terms?
What is meant by joins? List out the types of joins.
Explain overloading. Can functions be overloaded?
Explain the use of grant option in exp command.
How to upsert (update or insert into a table)?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
Which dictionary tables and/or views would you look at to diagnose a locking issue?
How to define an anonymous block?
What is the difference between online and offline backups?
How can we delete duplicate rows in a table?
How to connect asp pages to oracle servers?
Difference between varchar and varchar2 data types?
How to open a cursor variable?