Як вибрати всі записи з таблиці "orders", які були створені в період з 01.01.2023 до 31.12.2023?

Question

Answer

SELECT * FROM orders WHERE order_date IN ('2023-01-01', '2023-12-31')

Answer

SELECT * FROM orders WHERE order_date >= '2023-01-01' AND order_date <= '2023-12-31'

Answer

SELECT * FROM orders WHERE order_date > '2023-01-01' AND order_date < '2023-12-31'

Answer

SELECT * FROM orders WHERE order_date BETWEEN '2023-01-01' TO '2023-12-31'

Answer

SELECT * FROM orders WHERE order_date BETWEEN '2023-01-01' AND '2023-12-31'

Crowdly