Contents of the ORDERS table -Based upon the contents of the ORDERS table in the accompanying figure,which of the following queries will display all orders shipped between April 4,2003 and April 5,2003? A) SELECT * FROM orders WHERE shipdate = '05-APR-03'; B) SELECT * FROM orders WHERE shipdate BETWEEN '04-APR-03' AND '05-APR-03'; C) SELECT * FROM orders WHERE shipdate = '04-APR-03' AND shipdate

Question

Contents of the ORDERS table -Based upon the contents of the ORDERS table in the accompanying figure,which of the following queries will display all orders shipped between April 4,2003 and April 5,2003? A) SELECT * FROM orders WHERE shipdate <= '04-APR-03' AND shipdate >= '05-APR-03'; B) SELECT * FROM orders WHERE shipdate BETWEEN '04-APR-03' AND '05-APR-03'; C) SELECT * FROM orders WHERE shipdate >= '04-APR-03' AND shipdate <= '05-APR-03'; D) both b and c

Quizplus · Accepted Answer

Both options B and C correctly use the SQL BETWEEN operator and logical operators (>= and <=) respectively to specify a range that includes both the start and end dates (April 4, 2003, and April 5, 2003). This ensures that all orders shipped on those dates are selected.

Contents of the ORDERS Table