Which of the following will return all orders shipped after April 5, 2005? SELEC

Question

Which of the following will return all orders shipped after April 5, 2005?

SELECT *
FROM orders
WHERE shipdate > '05-04-05';

SELECT *
FROM ORDERS
WHERE shipdate < '05-APR-05';

SELECT *
FROM orders
WHERE shipdate > APR-05-05;

SELECT *
FROM orders
WHERE shipdate > '05-APR-05';

SELECT *
FROM orders
WHERE shipdate > '05-04-05';

SELECT *
FROM ORDERS
WHERE shipdate < '05-APR-05';

SELECT *
FROM orders
WHERE shipdate > APR-05-05;

SELECT *
FROM orders
WHERE shipdate > '05-APR-05';

Explanation / Answer

Generally to retrieve any information from the database after a specific date, query syntax is in the following formate:

select * from table_name where date_column > 'YYYY-MM-DD';

although

select * from table_name where date_column > 'YY-MM-DD';

it will also works.
So right answer is

(a)

SELECT *
FROM orders
WHERE shipdate > '05-04-05';

Hope this helps!
kindly appreciate the help by upvoting the answer. Thank you!

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.