Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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.

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


Please Help Members By Posting Answers For Below Questions

How do I reset a sequence in oracle?

1106


How to define an anonymous procedure without variables?

1111


How many anonymous blocks can be defined?

1191


How does one get the view definition of fixed views/tables?

1023


What is oracle analytical function?

1153


What are the predefined tablespaces in a database?

1088


How do I uninstall oracle client from windows?

1014


What is the purpose of save points in oracle database?

1124


How to convert character types to numeric types?

1139


What is a nvl function? How can it be used?

1037


What is ordinary table in oracle?

1162


Name the various constraints used in oracle?

1023


What are the oracle built-in data types?

1080


How translate command is different from replace?

1091


What is truncate oracle?

977