The greater than or equal to operator (>=) returns TRUE when a value is either greater than or exactly equal to another value. It is commonly used when a threshold value itself should also be included in the results.
Business rules often include a minimum acceptable value. For example, a company may want employees earning at least ₹50,000 or transactions of ₹10,000 or more.
To find employees earning ₹50,000 or more, the >= operator can be used.
SELECT
EmployeeName,
Salary
FROM Employees
WHERE Salary >= 50000;This operator is useful for salary thresholds, minimum transaction values, minimum stock levels, age-based filtering, and date-based reporting.
- >= means greater than or equal to.
- It includes the boundary value.
- It can be used with numbers.
- It can be used with dates.
- It is useful for minimum-threshold conditions.
What does >= mean in SQL?
It means greater than or equal to and includes the specified boundary value.
Does >= include the compared value?
Yes. If the value is exactly equal to the specified value, it is included.