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
- 6799 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 is index?
query optmization techniques and quwry analyser+projects+ppts
How to declare a local variable?
how can get like this result table A col1 col2 --- ----- a A b B C C .. .. .. ... .. ... wants result like for a single column col1 ------ a,b,c,........n of data and another is col1 ------- A B C D ........ a b b d ........
What is set operator oracle?
What is clustered table in Oracle?
I know that i can create a table without a primary key.But is there any significance for that table???? while creating an application.
What is the recommended interval at which to run statspack snapshots, and why?
How to experiment a data lock in oracle?
There is a big table with "n" of rows and 40 + columns .It doesn't have primary key.How do you select the primary key. In other words how do you get the duplicate records.
State the difference between a primary key and foreign key?
What privilege is needed for a user to insert rows to tables in another schema?
Oracle General 
