SQL

SQL Greater Than or Equal to Operator

-- returns records where amount is greater than or equal to 400
SELECT order_id, item, amount
FROM Orders
WHERE amount >= 400;

SQL Less Than or Equal to Operator

-- returns records where amount is less than or equal to 400
SELECT order_id, item, amount
FROM Orders
WHERE amount <= 400;

sql greater than

select greatest(1,2,3,4,5);

SQL Greater than (>)

SELECT *
FROM Customers
WHERE age > 25;

SQL Less Than Operator

-- returns records where amount is less than 400 (exclusive)
SELECT order_id, item, amount
FROM Orders
WHERE amount < 400;

SQL Greater Than Operator

-- returns records where amount is greater than 400 (exclusive)
SELECT order_id, item, amount
FROM Orders
WHERE amount > 400;