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

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

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

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

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

Blob

Integer

Double

Boolean

String

INSERT INTO

ADDROW

CREATE RECORD

NEW DATA

PUT INTO

SELECT * FROM products WHERE price <= 100 AND category NOT LIKE 'електроніка'

SELECT * FROM products WHERE price <= 100 AND category NOT 'електроніка'

SELECT * FROM products WHERE price <= 100 AND category != 'електроніка'

SELECT * FROM products WHERE price <= 100 AND category NOT EQUAL 'електроніка'

SELECT * FROM products WHERE price <= 100 OR category <> 'електроніка'

DROP TABLE employees

TRUNCATE employees

REMOVE TABLE employees

DELETE TABLE employees

DROP employees

INSERT

UPDATE

ALTER

REPLACE

MODIFY

CHECK NULL

HAS VALUE

IS NOT NULL

IS NULL

NOT EMPTY

SEARCH

PATTERN

EQUAL

MATCH

LIKE

SELECT * FROM orders WHERE date >= '2023-11-01'

SELECT * FROM orders WHERE date <= '2023-11-01'

SELECT * FROM orders WHERE date > '2023-11-01'

SELECT * FROM orders WHERE date < '2023-11-01'

SELECT * FROM orders DATE > '2023-11-01'

250

True

False

1,254

Null