Beginner

356. Greater Than or Equal To

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

📘 Lesson 356 of 728 ⏱ 8 min 🎯 Beginner

The greater-than-or-equal operator (>=) returns true when a value is either greater than or exactly equal to the comparison value.

Many business rules include a minimum threshold, so analysts frequently need to include the boundary value.

Find employees whose salary is ₹50,000 or higher.

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

It is useful for eligibility rules, salary bands, sales targets, credit thresholds, and performance criteria.

  • The operator is >=.
  • It includes the comparison value.
  • It can represent minimum thresholds.
  • It is useful for business rules.
  • It can be combined with other conditions.
What does >= mean?

It means greater than or equal to the specified value.

Does >= 50000 include exactly 50000?

Yes. The equal part means 50000 is included.

Have you finished this lesson?

Introduction to SQL – All Lessons