Beginner

169. Less Than Operator

Learn how the less-than operator filters values below a specified value.

📘 Lesson 169 of 728 ⏱ 7 min 🎯 Beginner

The less-than operator (<) returns rows where one expression has a value less than another expression.

Less-than conditions are useful for identifying records below business thresholds or within specific ranges.

Find products with a price below ₹1,000.

SQL 
SELECT
    ProductName,
    Price
FROM Products
WHERE Price < 1000;

It is commonly used for price analysis, age analysis, transaction thresholds, inventory monitoring, and performance reporting.

  • < means less than.
  • It excludes values equal to the threshold.
  • It can compare numbers and ordered values.
  • It is commonly used with WHERE.
  • It supports threshold-based analysis.
What does < mean in SQL?

It returns values that are less than the specified comparison value.

Does Price < 1000 include 1000?

No. The less-than operator excludes the value that is exactly equal to 1000.

Have you finished this lesson?

Introduction to SQL – All Lessons