Do you want BuboFlash to help you learning these things? Or do you want to add or correct something? Click here to log in or create user.


  • Presentation
  • Question
  • Answer

Tags
#has-images
Question
The following statement returns the orders placed by customers between December 1, 2016, and December 31, 2016:
Answer

SELECT order_id, customer_id, status, order_date FROM orders WHERE order_date BETWEEN DATE '2016-12-01' AND DATE '2016-12-31' ORDER BY order_date;

Here is the result:


Tags
#has-images
Question
The following statement returns the orders placed by customers between December 1, 2016, and December 31, 2016:
Answer
?

Tags
#has-images
Question
The following statement returns the orders placed by customers between December 1, 2016, and December 31, 2016:
Answer

SELECT order_id, customer_id, status, order_date FROM orders WHERE order_date BETWEEN DATE '2016-12-01' AND DATE '2016-12-31' ORDER BY order_date;

Here is the result:

If you want to change selection, open document below and click on "Move attachment"

Oracle BETWEEN: Select Rows Whose Values are in a Range
ost NOT BETWEEN 500 AND 600 ORDER BY product_name; The following illustrates the result: B) Oracle BETWEEN dates example Let’s use the orders table in the sample database for the demonstration: <span>The following statement returns the orders placed by customers between December 1, 2016, and December 31, 2016: 1 2 3 4 5 6 7 8 9 10 11 SELECT order_id, customer_id, status, order_date FROM orders WHERE order_date BETWEEN DATE '2016-12-01' AND DATE '2016-12-31' ORDER BY order_date; Here is the result: In this tutorial, you have learned how to use the Oracle BETWEEN operator to select rows that are in a specific range. Was this tutorial helpful? yesno Previous Tutorial: Oracle IN Next

Summary

statusnot learnedmeasured difficulty37% [default]last interval [days]               
repetition number in this series0memorised on               scheduled repetition               
scheduled repetition interval               last repetition or drill

Details

No repetitions

Discussion

Do you want to join discussion? Click here to log in or create user.