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
- 5652 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / subhajit acharyya
select clientnumber,ordate,shipping date from order where
months_between(shipping date,ordate) between 3 and 6;
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / devraj
Select custid, ordid, shipdate From ord Where (shipdate -
orderdate) Between 3 And 6;
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / 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 |
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
Give the various exception types.
can u call user defined functions in select statements
What is the string concatenation operator in oracle?
What happens to the current transaction if the session is killed?
How do we know whether an index is created on a table ???
ex. one table is having 1 column with 10 records , then how to display all the values in row wise ?
how to insert data into partitioned table partition done by Range partition
What is SQL Tuning Advisor in Oracle?
what is IDE,DMV in sql server?
what is the syntax of SELECT command?
SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)?
Oracle General 
