Beginner

357. Less Than or Equal To

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

📘 Lesson 357 of 728 ⏱ 8 min 🎯 Beginner

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

Many business rules define maximum limits, making <= an important filtering operator.

Find transactions of ₹10,000 or less.

SQL 
SELECT
    TransactionID,
    Amount
FROM Transactions
WHERE Amount <= 10000;

It is useful for transaction limits, pricing rules, age criteria, budget controls, and operational thresholds.

  • The operator is <=.
  • It includes the comparison value.
  • It represents maximum thresholds.
  • It is useful in business rules.
  • It can be combined with AND and OR.
What does <= mean?

It means less than or equal to the specified value.

Does <= 10000 include exactly 10000?

Yes. The equal part means 10000 is included.

Have you finished this lesson?

Introduction to SQL – All Lessons