× Didn't find what you were looking for? Ask a question
Top Posters
Since Sunday
1
1
Home Q & A Board Other Fields Homework Help Business Management
New Topic  
Shann_5501 Shann_5501
wrote...
Go to Answer
Posts: 634
Rep: 0 0
6 years ago
Based upon the contents of the ORDERS table, which of the following SQL statements will display the number of days between the date an order was placed and the date it was shipped?
 a. SELECT order, TO_CHAR(shipdate-orderdate, '99') FROM ordersWHERE shipdate IS NOT NULL;
  b. SELECT order, MONTHS_BETWEEN(shipdate-orderdate, '99') FROM ordersWHERE shipdate IS NOT NULL;
  c. SELECT order, ADD_MONTHS(shipdate-orderdate, '99') FROM ordersWHERE shipdate IS NOT NULL;
  d. SELECT order, DAYS_BETWEEN(shipdate-orderdate, '99') FROM ordersWHERE shipdate IS NOT NULL;
Read 64 times
1 Reply
Replies
Answer verified by a subject expert
Jumana00Jumana00
wrote...
#1
Top Poster
Posts: 918
Rep: 7 0
6 years ago
Sign in or Sign up in seconds to unlock everything for free
1

Related Topics

Shann_5501 Author
wrote...

6 years ago
Thank you, thank you, thank you!
7.prime7105
wrote...

Yesterday
This helped my grade so much Perfect
mkyoungs
wrote...

2 hours ago
Just got PERFECT on my quiz
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  943 People Browsing
 131 Signed Up Today
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Live Chat
Related Images
  
 300
  
 351
  
 1627
Your Opinion
What percentage of nature vs. nurture dictates human intelligence?
Votes: 432
Previous poll results: Which country would you like to visit for its food?