Beginner

170. Greater Than or Equal To

Learn how to filter values that are greater than or equal to a specified value.

📘 Lesson 170 of 728 ⏱ 7 min 🎯 Beginner

The greater-than-or-equal operator (>=) returns rows where a value is greater than or equal to the comparison value.

Many business rules include the boundary value itself, making >= important for accurate filtering.

Find employees whose salary is at least ₹50,000.

SQL 
SELECT
    EmployeeName,
    Salary
FROM Employees
WHERE Salary >= 50000;

It is useful for minimum salary requirements, credit limits, sales targets, age criteria, and performance thresholds.

  • >= means greater than or equal to.
  • It includes the boundary value.
  • It is commonly used with numeric values.
  • It can be used with dates and other ordered values.
  • It is useful for minimum thresholds.
What does >= mean in SQL?

It returns values that are greater than or equal to the specified comparison value.

Does Salary >= 50000 include 50000?

Yes. The greater-than-or-equal operator includes the boundary value.

Have you finished this lesson?

Introduction to SQL – All Lessons