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.
Tags
#has-images
Question
To query products whose standard costs are not between 500 and 600, you add the
NOT operator to the above query as follows:Answer
| SELECT product_name, standard_cost FROM products WHERE standard_cost NOT BETWEEN 500 AND 600 ORDER BY product_name; |
The following illustrates the result:
Tags
#has-images
Question
To query products whose standard costs are not between 500 and 600, you add the
NOT operator to the above query as follows:Answer
?
Tags
#has-images
Question
To query products whose standard costs are not between 500 and 600, you add the
NOT operator to the above query as follows:Answer
| SELECT product_name, standard_cost FROM products WHERE standard_cost NOT BETWEEN 500 AND 600 ORDER BY product_name; |
The following illustrates 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
In this example, we compared the values in the standard cost ( standard_cost) column with a range from 500 to 600. The query returned only products whose standard costs are between that range: <span>To query products whose standard costs are not between 500 and 600, you add the NOT operator to the above query as follows: 1 2 3 4 5 6 7 8 9 SELECT product_name, standard_cost FROM products WHERE standard_cost 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: The following statement returns the orders placed by customers between December
Oracle BETWEEN: Select Rows Whose Values are in a Range
In this example, we compared the values in the standard cost ( standard_cost) column with a range from 500 to 600. The query returned only products whose standard costs are between that range: <span>To query products whose standard costs are not between 500 and 600, you add the NOT operator to the above query as follows: 1 2 3 4 5 6 7 8 9 SELECT product_name, standard_cost FROM products WHERE standard_cost 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: The following statement returns the orders placed by customers between December
Discussion
Do you want to join discussion? Click here to log in or create user.